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 SQL Basics and Standard SQL Functions courses, or if you have equivalent knowledge, 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. You will help Kate who runs an electronics store. She would like to gather data to help her expand her business. Can you find out the average number of purchases made per customer? Can you calculate the prices for customers with loyalty cards? The answers are in the database. You just need to figure out how to get them out using SQL functions.
Hint: In each exercise, you can see a sample of the data. Look in the right-hand menu, under thetab.
Practice writing SQL queries with our SQL coding practice! Every month, we release a new set of interactive exercises with real-time feedback.