Please provide SQL queries for all of the following questions. You should use the University database that we used in class.

Please provide SQL queries for all of the following questions. You should use the University database that we used in class. Your submission document should contain both your SQL queries and results for each question (In MySQL workbench menu on the top of the interface, select “Query” and then select “Execution (All or Selection) to Text”, so that you can copy and paste the results table returned). If some of your queries cannot run through, you still need to include these queries in your submission for grading. Paste the queries and results to a word document named as “TeamMemberFirstName(s)_HW3.docx” and submit this document to Canvas.

1. List the first name and last name of all assistant professors fromSeattle.

1. List the first name and last name of all students who had classes on Monday during the spring semester of 2003.

3.        List the average salary of all MS professors by their rank.

1. List the first name and last name of all faculties who are supervised by Leonard Fibon.

1. Foreach of the offering, list the average entering grade (EnrGrade) of enrolled studentsby major. Only display the majors in each offering (the combinations of offering and major) that have an average entering gradegreater than 3.2. Display your result in the ascending order of offering number. [Hint: 12 rows will be retrieved, in the format of “offering… major… average”.]

1. For each of theIScourse offerings, list the course number, offering number, the first and last name of the faculty who is assigned to this offering, as well as the first and last name of the supervisor of this assigned faculty.  Including the offering and faculty informationeven ifthe offering hasnoassigned faculty and/or the faculty hasnosupervisor. [Hint: 10 rows will be retrieved.]

1. Using a Type I nested query, list the STdSSN, StdFirstName, StdLastName of all students who enrolled in IS480 during the winter of 2003.

1. Using a Type II nested query, retrieve a list of courses (list their course number and course description) that were not offered in winter2003.