52

Orders Above Average

MediumsubqueryAVG

Problem Description

Write a SQL query to find orders with amount above the average order amount.

Expected Columns

  • id
  • amount

Example Output

| id | amount | |----|--------| | 1 | 76500.0 | | 5 | 25000.0 | | 7 | 75000.0 | | 11 | 27500.0 | | 15 | 76500.0 |

Hints

Unlocks after 2 more attempts
Submit your solution to unlock hints
//#52 Orders Above Average
Medium

Loading schema...

Loading editor...

No results yet

Run a query to see results