Each question below should be answered with one query using SQL Server Management Studio. Use the data in the ERDs at the end of this post to create the queries. Question 3 uses the Project/Manager ERD and questions 4, 5, and 6 use the Course Information ERD.

/* 3. List the name of each parent project and the number of subprojects related to it. */

/* 4. Generate a list of department names that do not offer any classes. */

/* 5. Generate the names of all Finance courses that do not require any prerequisite. Assume that you do not know the deptID for the Finance department. Use a subquery. */

/* 6. List the number of prereqs for each course. Include courses that do not have any prereqs. Only display the first 12 results. */

Course Information (not all fields in tables are shown) Project / Manager ERD Course Information (not all fields in tables are shown) Project / Manager ERD