Must turn in all code, including the code to create stored procedures. You will not be graded based on stored procedures you create in the database. 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.

DIPOSITION_TYPE tbIINSTRUCTOR TYPE Instructorld DIINSTRUCTOR OFFICE IncrOttimo the NSTRUCTOR lirat r ome Cth OFFICE tblINSTRUCTOR INSTRUCTOR TYPE start.tardo Intro Login Erdote Piante Ir.com Irctica tblOFFICE TYPE OfficeType Ottica pa OfficeTypeler Dagina EndDate Chip Itt Intip tblPOSITION Scam tbiSTAFF POSITION Stuttbution thiNSTRUCTOR CLASS P rotector Positione tbISPECIAL NEED Speed LLISTUDENT SPECIAL NEED Student BeginData Erdo Deri tb ISTUDENT STATUS Special eder tbISTAFF Susanto Soft SD S/N thSTUDENT tbIQUARTER Studente Studente Studenter thlSTUDENT_DORMROOM Suomi tbISTATUS SD LIDEPARTMENT Quarteirih Quart Month Det Studenten Danman Basi Date College Dept Dec Stud ium tb COLLEGE College CollegeDex tblCLASS LIST Strada tbIDORM ROOM tbICLASS DotOfDeath er Couro tbIDORMROOM TYPE DeliiType Dark Darremtyper tbICOURSE Couro Der Dorway Rysune Sche LICLASSROOM Cimonio Cleme LLIBUILDING Bug Building tbiSCHEDULE TIDAY DO Dayane tblBUILDING TYPE Dulcego Scheme THISCHEDULE DAY (I KATION Damer DICLASSROOM TYPE Clausompel Clemson Type Camper Det Share Schesi Quilding Dance OldSortime Ver Opered DIPOSITION_TYPE tbIINSTRUCTOR TYPE Instructorld DIINSTRUCTOR OFFICE IncrOttimo the NSTRUCTOR lirat r ome Cth OFFICE tblINSTRUCTOR INSTRUCTOR TYPE start.tardo Intro Login Erdote Piante Ir.com Irctica tblOFFICE TYPE OfficeType Ottica pa OfficeTypeler Dagina EndDate Chip Itt Intip tblPOSITION Scam tbiSTAFF POSITION Stuttbution thiNSTRUCTOR CLASS P rotector Positione tbISPECIAL NEED Speed LLISTUDENT SPECIAL NEED Student BeginData Erdo Deri tb ISTUDENT STATUS Special eder tbISTAFF Susanto Soft SD S/N thSTUDENT tbIQUARTER Studente Studente Studenter thlSTUDENT_DORMROOM Suomi tbISTATUS SD LIDEPARTMENT Quarteirih Quart Month Det Studenten Danman Basi Date College Dept Dec Stud ium tb COLLEGE College CollegeDex tblCLASS LIST Strada tbIDORM ROOM tbICLASS DotOfDeath er Couro tbIDORMROOM TYPE DeliiType Dark Darremtyper tbICOURSE Couro Der Dorway Rysune Sche LICLASSROOM Cimonio Cleme LLIBUILDING Bug Building tbiSCHEDULE TIDAY DO Dayane tblBUILDING TYPE Dulcego Scheme THISCHEDULE DAY (I KATION Damer DICLASSROOM TYPE Clausompel Clemson Type Camper Det Share Schesi Quilding Dance OldSortime Ver Opered