Whenever you're ready, walk me through how you'd approach this.
How would you troubleshoot a SQL query that returns incorrect results after a join?
Discuss how you would isolate the cause, validate join keys and cardinality, identify duplicate or missing rows, and confirm that filters and aggregations are applied at the correct stage. Include relevant PostgreSQL examples where useful.