Products Above Category Average
Medium
subqueries
Amazon
Google
Stripe
Find all products whose price is above the average price of their own category. Return name, category, and price, ordered by category then price descending.
Expected Output: Products priced above the average for their category.
Tables
Hints (3 available)
SQL Editor
Output
Click "Run" to see results...