Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings. You can modify your browser settings on your own. For more information see our Privacy Policy.
Course
AdvancedCurious what juicy queries we've got for you this time? Be sure to check this month's challenge!
Welcome to our next SQL Practice! New tasks are waiting for you. If you’ve finished our Creating Basic SQL Reports course or if you have equivalent knowledge, this is a good way to test your database skills. You should be comfortable using CASE WHEN, GROUP BY, and aggregate functions. Are you ready to solve the problems in this month’s SQL practice?
In this story, you've just been hired as an SQL specialist. You will help Shelly who runs a coffee shop. Shelly would like to gather data to help expand the business. Can you find the most popular menu items? Can you calculate the total revenue in December 2022? The answers are hidden in the database. You just need to figure out how to get them out using SQL.
Hint: In each exercise, you can see a sample of the data. Look in the right-hand menu, under the tab.
Have fun!
Course progress
Exercises completed
1.
Practice writing SQL queries with our SQL coding practice! Every month, we release a new set of interactive exercises with real-time feedback.