Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Exercises with artists, museums and their pieces of art
Exercises with the band members table
Exercises with tables of Japanese 100 Yen store
Exercises with employees, salaries and benefits


Awesome job! That's enough musical querying for now. We've got a store to manage!

We'll focus on the sales of a Japanese 100 Yen store. It's a store where you can buy cheap products. Obviously, our database doesn't contain every transaction, client, or product. For our purposes, we'll look at a small sample.


Select all data from the categories table. It stores the names of product categories:

  • id – the ID of a given category.
  • name – the name of a given category.