Introduction
Exercises with artists, museums and their pieces of art
Exercises with the band members table
Exercises with tables of Japanese 100 Yen store
Instruction
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.
Exercise
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.
