Question: Use the database from HW8 Write the SQL Command to answer the following questions. Requirement: You must turn in the codes and their outputs. Email


Use the database from HW8 Write the SQL Command to answer the following questions. Requirement: You must turn in the codes and their outputs. Email submission is required and the HW file has to be in PDF format. There are two assumptions in this database; All courses start with the prefix of ISM, meaning that this database only capture courses for ISM program. I-2000 means the first semester of year 2000 and II-2000 means the second semester of year 2000. There are only 2 semesters in a year. Requirement: You must turn in the codes and their outputs from MS SQL Server. 1) What is/are the name of students who enrolled for section 2713? 2) What is/are the name of instructor(s) who became qualified to teach section 2712 after 2001? 3) What is/are the name or instructor(s) who can teach at least 2 courses in ISM program? 4) What is the name of courses that have more than 2 sections? 5) What is the name of instructor(s) who might be LeterSky's teachers since year 2000? 6) Which course (s) has/have the fewest number of student enrolled in I-2001 semester (identify COURSE_ID)? You don't have to include courses that did not have enrollment. 7) Who is/are the name of instructor(s) who cannot teach any course? 8) What is the name of the course that has fewest numbers of sections? 9) What is the name of students who has enrolled for Database course since year 1995? 10) How many students have enrolled for the Networking courses
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
