Question: Using the below University schema, write a SQL query that returns the FirstName and number of CS courses (Department- 'CS) for all students who are


Using the below University schema, write a SQL query that returns the FirstName and number of CS courses (Department- 'CS) for all students who are enrolled in one or more CS courses. Sort your results first by number of CS courses (in descending order) and then by FirstName (in ascending order) Input Format The Students, Enrollments and Courses table are defined as follows Students Column Name Type Netld FirstName LastName Department VARCHAR(10) VARCHAR(255) VARCHAR(255) VARCHAR(100)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
