Whenever you're ready, walk me through how you'd approach this.
Explain joins in DBMS.
Describe how joins combine rows from related tables, including the differences between INNER, LEFT, RIGHT, FULL OUTER, CROSS, and self joins. Explain how unmatched rows and NULL values are handled, and give concise PostgreSQL examples.