Whenever you're ready, walk me through how you'd approach this.
Tell me about how you would solve SQL problems involving joins, window functions like rank, and common table expressions (CTEs).