Priced above the pack — SQLPlayground

hard9. Priced above the pack

Find events whose ticket price is above the average price of their own category. Show the name, price, and the category average. (Hint: correlated subquery.)

-- Challenge 9: Priced above the pack
-- 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.