On January 21th at 14:15 UTC , progression through exercises will be unavailable for 10 minutes due to a planned maintenance break.
Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close


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

player (id, name, ranking, country)

coach (id, player_id, 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 can be unemployed.

The columns should be obvious for you.


Show all coaches together with the players they train, show all columns for coaches and players. Show unemployed coaches with NULLs instead of player data.

Stuck? Here's a hint!

Use the following template to help you build your query:

FROM ...
  ON ...;