All Problems
80

Products with Revenue Above Average

HardsubqueryHAVINGaggregation

Problem Description

Write a SQL query to find products whose total revenue exceeds the average product revenue.

Expected Columns

  • product_name
  • total_revenue

Example Output

| product_name | total_revenue | |--------------|---------------| | Laptop Pro | 225000 | | Standing Desk | 50000 |

Hints

Unlocks after 2 more attempts
Submit your solution to unlock hints
//#80 Products with Revenue Above Average
Hard

Loading schema...

Loading editor...

No results yet

Run a query to see results