Scalar Subquery for Comparison
Medium
subqueries
JPMorgan
Capital One
PayPal
Write a query to find all products priced above the overall average price. Return name, price, and the avg_price (rounded to 2 decimals) as a column. Order by price DESC.
Expected Output: Products above average price, with the average shown.
Tables
Hints (3 available)
SQL Editor
Output
Click "Run" to see results...