Specify the following queries in SQL on the following database schema (keys are in bold and underline):

Consider the below schema of the university database (keys are in bold and underline):

Students(stuID: String, stuName: String, gender: String, birthdate: Date, enterYear: Year, gpa: Float)

Departments(deptName: String, numPhDs: Integer)

ProfessorWorks(profID: String, profName: String, deptName: String)

CourseOffers(cNo: String, cTitle: String, deptName: String)

Majors(deptName: String, stuID: String, degreeProgram: String, attendSemester: String, attendYear: String)

Sections(cNo: String, academicYear: String, semester: String, sectNo: String, profID: String, meetsAt: String, room: String)

Enrolls(stuID: String, cNo: String, academicYear: String, semester: String, sectNo: String, grade: String)

These tables have been created and the data have been populated using MySQL server. Download DBHW4s17.sql to your computer and run it on MySQL. Execute your SQL statements based on these tables. Turn in your SQL queries statements and the results of these queries to the assignment link.

Write the following queries in SQL statements. The query answers must not contain duplicates, but you should use the SQL keyword DISTINCT only when necessary. When your SQL query statement is not accepted by MySQL, it will display error messages. You need to read that message and fix all problems accordingly. Note that MySQL does not support INTERSECT and EXCEPT currently. When you need to find the intersection and difference of two result sets, you can use IN and NOT IN instead. In addition, for this assignment, creation of temporary tables is not allowed, i.e., for each question you have to write exactly one SQL statement.

Print the name(s) of professor(s) who teaches class(es) for the Information Technology department. Note that Information Technology is a department name.

Print the names of departments that have one or more students whose GPA is above 3.50.

Print the age of the oldest and youngest student(s) per department. Note that MySQL provides several functions for performing calculations on DATE. The function TIMESTAMDIFF() can be used to convert the date of birth to age. Several examples are available at https://dev.mysql.com/doc/refman/5.7/en/date-calculations.html.

Print the name(s) and sid(s) of the student(s) enrolled in at least three classes in Fall 2016.

Find the names of students who have enrolled in both ITT 226 and Math 461 in Fall 2016. Note that ITT 226 and Math 461 are course numbers (cNo).