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 returnsthe FirstName and number of CS courses (Department- 'CS) for all students

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!