SQLKATA- Evergreen High School's A cademic Database
Created 1 mon ago
23
Views
2
Comments
@NandhiniVaradharajan
Question No.4
SELECT c.name AS course_name, COUNT(e.student_id) AS enrollment_count
FROM enrollments e
JOIN courses c ON e.course_id = c.id
GROUP BY c.name
ORDER BY enrollment_count DESC;
Hey guys, I just tried This query with my level of understanding in SQL.Could anyone help with this to spot any error in it!?