Hi, I really need help with this project

• Write the queries that return the results listed below (Save file as UniversityQueries.sql)

Query 1: Report showing the number of courses in each college.

College	Courses
College of Business and Communication	3
College of Language and Letters	1

Query 2: Report showing the total number of students each professor can teach (capacity) broken out by term.

Name	Year	Term	TeachingCapacity
Barney	2017	Winter	35
Barrus	2016	Fall	35
Jensen	2016	Fall	30
Jensen	2017	Winter	30
Morring	2016	Fall	30
Morring	2017	Winter	30
Nate	2016	Fall	100
Nate	2017	Winter	100

Query 3: Report showing the actual number of students taught by each professor broken out by term.

Name	Year	Term	StudentCount
Barney	2017	Winter	1
Barrus	2016	Fall	3
Jensen	2016	Fall	2
Jensen	2017	Winter	1
Morring	2016	Fall	1
Morring	2017	Winter	2
Nate	2016	Fall	1
Nate	2017	Winter	3

Query 4: Report showing a list of the professors Bryce will have in Winter 2017.

Name

Morring

Nate

Jensen

Query 5: Report showing a list of students that take Econometrics in Fall 2016.

Name

Katie

Kelly

Mandy

Query 6: Report showing students total credit load by term. Sort by Year and Term in ascending order and then Credits in descending order.

Name	Term	Year	Credits
Paul	Fall	2016	6
Mandy	Fall	2016	6
Kelly	Fall	2016	4
Katie	Fall	2016	4
Devon	Fall	2016	2
Bryce	Winter	2017	8
Julia	Winter	2017	3
Preston	Winter	2017	3
Alece	Winter	2017	3
Susan	Winter	2017	3

Query 7: Report showing students total credit load by term but only students with a credit load greater than three. Sort by Year and Term in ascending order and then Credits in descending order.

Name	Term	Year	Credits
Paul	Fall	2016	6
Mandy	Fall	2016	6
Kelly	Fall	2016	4
Katie	Fall	2016	4
Bryce	Winter	2017	8

Query 8: Report showing students and their birthdays of students born in September.

Name	DOB
Preston	1996-09-22
Julia	1998-09-22
Susan	1998-09-08

Query 9: Report showing students age in years and days as of Jan. 5, 2017. Sorted from oldest to youngest. (You can assume a 365 day year and ignore leap day.)

Name	Years	Days	YearDays
Katie	21	173	21-Yrs 173-Days
Paul	20	323	20-Yrs 323-Days
Preston	20	110	20-Yrs 110-Days
Mandy	20	49	20-Yrs 49-Days
Alece	19	233	19-Yrs 233-Days
Bryce	19	49	19-Yrs 49-Days
Kelly	18	202	18-Yrs 202-Days
Susan	18	124	18-Yrs 124-Days
Julia	18	110	18-Yrs 110-Days
Devon	16	171	16-Yrs 171-Days

Pd: I attached a screenshot of the same date. just in case.

THANKS!!!!

Transcribed Image Text:

Query 1: Report showing the number of courses in each college. College Courses College of Business and Communication College of Language and Letters 1 Query 2: Report showing the total number of students each professor can teach (capacity) broken out by term. Name Year Term TeachingCapacity Barney 2017 Winter 35 Barrus 2016 Fall 35 Jensen 2016 Fall 30 Jensen 2017 Winter 30 Morring 2016 Fall 30 Morring 2017 Winter 30 Nate 2016 Fall 100 Nate 2017 Winter 100 Query 1: Report showing the number of courses in each college. College Courses College of Business and Communication College of Language and Letters 1 Query 2: Report showing the total number of students each professor can teach (capacity) broken out by term. Name Year Term TeachingCapacity Barney 2017 Winter 35 Barrus 2016 Fall 35 Jensen 2016 Fall 30 Jensen 2017 Winter 30 Morring 2016 Fall 30 Morring 2017 Winter 30 Nate 2016 Fall 100 Nate 2017 Winter 100

Answer rating: 100% (QA)

Answers Query 1 select from colleges Explanation The query works if data is stored in a table called colleges and contains College and Courses as its ... View the full answer