Database: bakery_1
Question: Give me the distinct id and price for all goods whose price is below the average of all goods?
SQL:
SELECT DISTINCT id ,  price FROM goods WHERE price  <  (SELECT avg(price) FROM goods)