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

All right, another exercise coming your way!

Exercise

Show first and last name of each client and the number of orders they placed.

Stuck? Here's a hint!

Remember to use a LEFT JOIN to see who haven't ordered anything.

Console

Code editor

Result

TableConsole