Introduction
Exercises with artist, 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

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.

Console

Code editor

Result

TableConsole