From the course: MySQL Database Administration

Unlock this course with a free trial

Join today to access over 24,500 courses taught by industry experts.

Challenge: Stored procedures

Challenge: Stored procedures - MySQL Tutorial

From the course: MySQL Database Administration

Start my 1-month free trial Buy for my team

Challenge: Stored procedures

“

- [Instructor] All right, we are ready for your assignment on stored procedures. So for this assignment, you're going to be working with Joe again from the Sloppy Joe's restaurant. As he scales up his business, he'd like to have a very quick way to query how many orders each staff member has served all time. He's not a database pro at all, so he wants us to be as simple as possible. He would love something as simple as a one line call, which will enable him to pull up those results. So take a look at this select statement here with a group by. This is the report that you're going to try to be baking into a new stored procedure called sp_staffOrdersServed. Again, this isn't a super complicated query to put into a stored procedure. But I think it's a very good example of a real-world situation where you have Joe who really isn't going to be writing SQL queries, he's just trying to run his business. But he would love this report and putting in the one line called sp_staffOrdersServed is…

Contents