Whenever you're ready, walk me through how you'd approach this.
What is your experience level with SQL, and how do you use joins, subqueries, and window functions?