The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/tutorial-join.html
Description:
The data is incomplete for results on all possible joins, given as an
exercise.
Help the student by introducing a temporary fake city, with no matching
weather data.
With that the left, right and full join will truly show a student different
results.
Thanks, francis