Question
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
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!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started