Whenever you're ready, walk me through how you'd approach this.
How would you write a query to get the top X results grouped by Y when the solution requires joins?