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

And naturally, clients place orders!

Exercise

Select all data from the orders table. It consists of the following four columns:

  • id – the id of a given order,
  • client_id – the id of the client who placed a given order,
  • year – the year a given order was placed,
  • total_price – the yen total value of a given order.

Console

Code editor

Result

TableConsole