How to Build Your Own Clubhouse: Session #2

[booleanhunter]

Video

Question #1. Test your knowledge of PostgreSQL JOINs

In the video, we construct a PostgreSQL query to return an array (rows) of rooms, along with their relevant info. Each row would contain the room id, name, its associated club-name, and the user-id & role of the participants in the speaker panel of that room. Using a RIGHT JOIN , we are able to get all rooms, including the ones that aren't within any club - 12 rows in total.

Question: Can you get the same results, but this time using a LEFT JOIN instead of a RIGHT JOIN? 😋

[dandan682]

HI! Sharing my LEFT JOIN homework 😊