These figures show college enrollments for a single semester. The sex field in t

Question

These figures show college enrollments for a single semester. The sex field in the Students table contains “M” for males and “F” for females, and the grade field in the Enrolls table contains a numerical grade, such as 4.0 for an “A”, 3.0 for a “B”, and so forth. Departments in the Courses table are identified by their names, which are unique

O SELECT course_name, COUNT (num_students*num_credits) AS total credits FROM courses AS C, sections AS S WHERE S.sectionnum = C.sectionnum GROUP BY course name ORDER BY total_credits DESC; - - O SELECT course_name, COUNT (student_num*num_credits) AS total_credits FROM courses AS C, enrolls AS E WHERE E.coursenum C.coursenum GROUP BY course name ORDER BY COUNT(student_num*num_credits) DESC, - - O SELECT course_name, SUM(num_students*num_credits) AS total_credits FROM courses AS C, sections AS S WHERE S.coursenum C.coursenum GROUP BY course name ORDER BY SUM(num_students*num_credits) DESC; - - O SELECT course_name, SUM(num_students*num_credits) AS total_credits FROM courses AS C, sections AS S WHERE S.coursenum C.coursenum GROUP BY course name ORDER BY total_credits DESC; - - O SELECT course_name, SUM(student_num*num_credits) AS total_credits FROM courses AS C, enrolls AS E WHERE E.coursenum C.coursenum GROUP BY course name ORDER BY SUM(student_num*num_credits) DESC, - -

Explanation / Answer

4.) SELECT course_name , SUM(num_students*num_credits) AS total_credits FROM courses AS c, sections AS s

where s.course_num=c.course_num

GROUP BY course_name

ORDER BY total_credits DESC;

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.