Whenever you're ready, walk me through how you'd approach this.
How would you write a SQL query using joins and subqueries to combine data from multiple source tables?
Explain how you would identify relationships between tables, choose appropriate join types, and use subqueries when intermediate filtering or aggregation is required. Discuss how you would handle duplicate rows, NULL values, and performance considerations.