Show product_name, price and store_avg (the average price of all products,
rounded to 2 decimal places) for the products priced above the average price.
End your query with ORDER BY price DESC, product_name.
| products |
|---|
| product_id (PK) |
| product_name |
| price |
Show product_name, price and store_avg (the average price of all products,
rounded to 2 decimal places) for the products priced above the average price.
End your query with ORDER BY price DESC, product_name.
| products |
|---|
| product_id (PK) |
| product_name |
| price |
| product_name | price | store_avg |
|---|---|---|
| VoltBook Air 14 Laptop | 68990.00 | 5701.32 |
| PixelTab 11 Tablet | 32999.00 | 5701.32 |
| Nova X5 Smartphone | 24999.00 | 5701.32 |
| Air Fryer 4.5L | 8999.00 | 5701.32 |
Run query to see output