Queries inside queries: subqueries, WITH and EXISTS · exercise 1 of 1 · free preview
A subquery in brackets runs first and gives a value you can compare with. It is like a helper cell that holds the average.
Show the name and unit price of every product priced above the average unit price. Lowest price first.
Tables in this practice shop
customersproductsordersorder_items