USE MY-SQL. Reminder: stored procedure take parameters of 'names' as opposed to 'ID' values. USE ERD BELOW!

1. Write the query to determine the students who have spent more than $3,000 in RegistrationFees for Information School classes after 2010 who also have completed 12 credits of Public Health courses before 2016.

2. Write the query to list the Top 3 departments in Arts and Sciences ordered by most students completing a class with a grade of less than 3.4 between 2004 and 2013. HINT: look for the number of DISTINCT individuals who meet the condition NOT the number of classes. :-)

3. Write the query to determine the newest building on South campus that has had a Geography class instructed by Greg Hay before winter 2015.

4. Write the query to determine the staff person currently-employed who has been in their position the longest for each college.

5. Write the query to determine the TOP 3 classroom types (and their COUNT) that have been most-frequently assigned for 300-level Anthropology courses since 1983.

6. Write the code to create a stored procedure to hire a new person to an existing staff position.

7. Write the code to create a stored procedure to create a new class of an existing course.

8. Write the code to create a stored procedure to register an existing student to an existing class.

Use the ERD BELOW!