Question: In the space below, write your SQL statements that perform the following tasks. Make sure to label your statements based on question numbers, and format

In the space below, write your SQL statements that perform the following tasks. Make sure to label your statements based on question numbers, and format your statements appropriately.
This part will be graded manually, so you do not see your grade right after your finishing it. Each question is worth 4 points.
1. Select the first and last names of all enrolled students and order by last name; remove duplication.
2. Select the course description, section number, and location for sections meeting in location L211.
3. Select the student IDs for the students enrolled in the most many of sections.
4. Select the first and last names of students who are not enrolled in any class.
5. Select the course number and total capacity for each course. Show only the courses with a total capacity less than the average capacity of all the sections.

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 Programming Questions!