https://mga.view.usg.edu/d2l/le/content/2746014/topics/files/download/54637761/DirectFileTopicDownload

g. List the first name, last name, office number, and school Name for all the administrators ordered by school name and last name. h. List the first Name, last name, and supervisor name for all teachers that were hired after 2010-01-01. i. Hint: I did a similar problem in this week's video. Will require a self-join on the teacher table. Remember tick marks around the date. 1) Download the Chicago schools db.sgl from the module 5 folder. Run the script to replace the database you made in the module 4 assignment with this new version https://mga.view.usg.edu/d21/le/content/2746014/topics/files/download/54637761/Direct FileTopicDownload Note: You may want to save the script to a simple directory (Ex: C: Iscripts) rather than your downloads directory. This will result in a much shorter pathname in your command. 2) Create and execute queries using the CLI in MySQL to answer the following questions. For your deliverables, take a separate screenshot for each query. Please include your query as well as the results. a. List the first name, last name, and date of birth for all students who were born after 2007-01-02 ordered by last name. i. Hint: remember to include tick marks around the date b. Hermione Granger has a student number of 1093. What was her highest grade? c. Abed Nadir has a student number of 2932. What was his lowest grade? d. Abed Nadir has a student number of 2932. What is his average grade? e. List the school name and number of students that attend the school. i. Remember when using an aggregate function, you need a group by statement. f. What two teachers have taught the least amount of time in the Chicago school system? i. Hint: you may find a subquery helpful here. There is a similar problem in this week's video as well if you need inspiration