Curious 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 know how to use CASE WHEN, GROUP BY, aggregate functions, and common table expressions (CTEs) in SQL, this is a good way to test your database skills. 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. Are you ready to use your database skills to help answer the business questions for Megan, the manager of a local theater? Can you find out which plays are the most popular? Can you calculate how many plays were staged each month?
The answers are hidden in the database, and it’s up to you to get them out. Practice your SQL skills and help her manage her business!
Hint: In each exercise, you can see a sample of the data. Look in the right-hand menu, under thetab.
Practice SQL with our coding challenges! Each month, there’s a new set of exercises to solve with real-time feedback.