1. How many faculty members have been hired for each rank since 2010? Write SQL statements to show the rank and the number of faculty members hired (i.e., how many).
2. Write SQL statements to show the course number and description for the MIS courses offered in the summer of 2011 in the Ross hall.
3. Write SQL statement to list the last name of the assistant professors who taught MIS courses in the fall of 2017.
4. List the last name and first name of the subordinates whom Victoria Emmanuel supervised.
5. For each faculty member who taught MIS classes, list the faculty last name and the average grade (EnrGrade) of the students he/she taught in those classes. List the average grade only if it is higher than 3.5. Arrange the outcome by the average grade so that the largest average comes first.
6.   Writing SQL Statements

Transcribed Image Text:

STUDENT StdNo StdFNam StdLName StdCity StdStat StdZip 123-45-6789 Homer FACULTY FacNo e 124-56-7890 Bob 1111 1234 098-76-5432 Leonard 543-21-0987 Victoria MIS320 MIS320 Wells Norbert COURSE CourseNo CrsDesc FIN300 MIS450 .... Seattle FacFName FacLName FacRank FacSalary Vince Assistant 85000.00 Emmanuel Associate 110000.00 OFFERING Offer No CourseNo OffTerm Off Year OffLocation OffTime e WA Bothell WA Fundamentals of Finance Database Summer 2017 Fall 2016 98121- 1111 Ross302 Steven302 98011- 2121 Crs Units 4 4 10:30 am 10:30 am StdMajo r IS FIN StdClass FacNo FR JR FacSupervisor 654-32-1098 StdGP A 3.00 2.70 (Note that OffLocation consists of two parts: building name and room number. For example, in Ross302, Ross is the building name and 302 is the room number.) FacHireDate 2004-04-10 2005-04-15 OffDay S 543-21-0987 MW 098-76-5432 MW STUDENT StdNo StdFNam StdLName StdCity StdStat StdZip 123-45-6789 Homer FACULTY FacNo e 124-56-7890 Bob 1111 1234 098-76-5432 Leonard 543-21-0987 Victoria MIS320 MIS320 Wells Norbert COURSE CourseNo CrsDesc FIN300 MIS450 .... Seattle FacFName FacLName FacRank FacSalary Vince Assistant 85000.00 Emmanuel Associate 110000.00 OFFERING Offer No CourseNo OffTerm Off Year OffLocation OffTime e WA Bothell WA Fundamentals of Finance Database Summer 2017 Fall 2016 98121- 1111 Ross302 Steven302 98011- 2121 Crs Units 4 4 10:30 am 10:30 am StdMajo r IS FIN StdClass FacNo FR JR FacSupervisor 654-32-1098 StdGP A 3.00 2.70 (Note that OffLocation consists of two parts: building name and room number. For example, in Ross302, Ross is the building name and 302 is the room number.) FacHireDate 2004-04-10 2005-04-15 OffDay S 543-21-0987 MW 098-76-5432 MW

Answer rating: 100% (QA)

To provide accurate SQL statements for these questions we will need to assume the names of the tables that hold the required data Based on the images ... View the full answer