Pricier Than Average
Medium · Subqueries
A subquery is a SELECT inside another query. A subquery that returns one value can be used like a number, for example WHERE price > (SELECT ...).
Return the name and price of every product whose price is greater than the average price of all products. Sort by price descending, then name ascending.