Database: bakery_1
Question: What are the distinct ids and prices for goods that cost less than the average good?
SQL:
SELECT DISTINCT id ,  price FROM goods WHERE price  <  (SELECT avg(price) FROM goods)