Whenever you're ready, walk me through how you'd approach this.
What is the purpose of a JOIN in SQL?
Explain how JOINs combine related data stored in separate tables. Cover how the matching condition works, the difference between INNER JOIN and OUTER JOIN behavior, and how unmatched rows are represented. The expected answer should include a concise PostgreSQL example and mention common risks such as duplicate rows and NULL values.