Whenever you're ready, walk me through how you'd approach this.
Explain how you would write a SQL query that uses joins and filters data, and describe how UNION ALL differs from UNION.