Your first day running the café's data.
You have learned the main parts of SQL. Today you put them all together. The café manager has gone home and left you a note with ten jobs. Each job uses something from one of the lessons, and every job has a hint if you need one.
“Hello, and welcome! Please could you check the menu, tell me who our best customer is, add the new Lemon Tart, put up the drink prices a little, and start collecting reviews. The full list is in the playground below. Thank you so much!”
All of SQL Café on one page
Here is everything you learned, with the memory line from each lesson. Please read it once before you start the jobs.
Ten jobs for the café
Please work through the jobs in order, because some build on earlier ones (you can't take an order for the Lemon Tart before it is on the menu). Your ticks are saved in this browser. If the tables get muddled, Reset tables puts them back, and you can redo the jobs that change tables.
Seven questions, one from each lesson
Please answer from memory. Each question comes from a different lesson, so it is a quick way to see what has stuck.
Finish all ten jobs to unlock it
has finished the SQL Café final project: reading, adding up, grouping, joining, changing and building tables with SQL.
When it unlocks, please take a screenshot to keep it.
Keep going
SQL Café is a free course by MASSH AI. Want SQL or data training for your team? Please get in touch.