08 Scalar

-- 08_scalar: Find products above the average price
-- Read-only reference query. Setup must be loaded first.
SELECT product_id,product_name,list_price FROM aabha_sql.products
WHERE list_price > (SELECT AVG(list_price) FROM aabha_sql.products)
ORDER BY list_price DESC,product_id;