Quiz
5. Task 4: Sophisticated INNER JOINs

Instruction

This quiz is too easy for you! Okay, let's see how much you remember about INNER JOINs.

Player (Id, Name, Ranking, Country)

Coach (Id, PlayerId, Name, Country)

We now have two tables with tennis players and their coaches. Each player can have one or more coaches. Each coach can train one player or be unemployed.

The columns should be self explanatory.

Exercise

Show all coaches together with the players they train. Show all columns for coaches and players. The player data for unemployed coaches should consist of NULLs.

Stuck? Here's a hint!

Use the following template to help you build your query:

SELECT
  ...
FROM ...
LEFT JOIN ...
  ON ...;