Top 2 by revenue per category

hard10. Top 2 by revenue per category

Show the top 2 highest-grossing events in each category, with their revenue rank. (Hint: compute revenue in a CTE, then ROW_NUMBER() over each category.)

-- Challenge 10: Top 2 by revenue per category
-- Write your query below, then press Ctrl+Enter (Cmd+Enter) to run.

Press Ctrl + ↵ to run

Results

Run a query to see results here — try clicking a table on the left, or pick a sample query above the editor.