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