Consider the student's database (used in the lectures and assignment) for the following questions. Write an SQL query and include a screenshot of your output in the answer sheet.

(a) (10 points) Create a list of courses, sections, and their capacity. Produce the result in the following format: Course and Section CAPACITY 350 Section 3 10 Section 2 20 Section 2 25 15 15

(b) (10 points) Display the course number, number of sections and total capacity for courses having more than 3 sections.

(c) (10 points) Write a SELECT statement to determine how many students enrolled in February 2007.

(d) (10 points) Show instructors (along with their course numbers and section numbers) teaching class sections with students whose last name begins with 'M'.

(e) (10 points) Show the number of enrollments for all sections of course number 122.

(t) (10 points) (use subqueries or correlated subqueries concepts). List courses and their description whose prerequisites are taught by Nina Schorin.

(g) (10 points). Using a correlated sub-query, display course name, course number and t average capacity of all sections of each course, rounded to 4 decimal places, where students are enrolled, and the average capacity is less than 25. Use a column alias o AVERAGE_CAPACITY to represent the number. (16 rows)