Are you interested in becoming an AWS Certified Solutions Architect?
Discover a new interactive way of training for the exam.
SELECT CC.COURSE_NUMBER, COURSES.COURSE_NAME, count(*) as COURSE_ENROLLMENT, ROUND(COUNT(CASE WHEN STUDENTS.ETHNICITY != '04' THEN 1 end)/ count(*) * 100) || '%' Minority FROM STUDENTS LEFT JOIN CC ON CC.STUDENTID = STUDENTS.ID LEFT JOIN S_CT_STU_DEMOGRAPHICS_X ON STUDENTS.DCID = S_CT_STU_DEMOGRAPHICS_X.STUDENTSDCID LEFT JOIN COURSES ON CC.COURSE_NUMBER = COURSES.COURSE_NUMBER WHERE CC.TERMID IN ('2600','2601','2602') AND STUDENTS.SCHOOLID IN ('61', '62') AND STUDENTS.ENROLL_STATUS = 0 AND COURSES.GRADESCALEID in (110,123) GROUP BY CC.COURSE_NUMBER, STUDENTS.ETHNICITY, COURSES.COURSE_NAME ORDER BY CC.COURSE_NUMBER
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.