db1993 Posted October 31, 2013 Share Posted October 31, 2013 Hello, I am having difficulties with this class work question List the various courseTitles, and for each course with the number of female students registered. Order the list by descending counts. The query I have used so far: SELECT course.courseTitle, COUNT(DISTINCT student.sex) FROM course, student WHERE student.sex = 'f' There are 2 Course Titles but the output of the above query only displays the first Course Title instead of both. Also, instead of displaying the count of 'F' (females) as 6 it displays it as 1 Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.