Whenever you're ready, walk me through how you'd approach this.
Can you explain the difference between inner join and outer join in SQL?
Discuss which rows each join type returns, how unmatched records are represented, and when you would choose an INNER JOIN, LEFT JOIN, RIGHT JOIN, or FULL OUTER JOIN. Include concise PostgreSQL examples.