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.

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more