Database: coffee_shop
Question: Find the id and address of the shops whose score is below the average score.
SQL:
SELECT shop_id ,  address FROM shop WHERE score  <  (SELECT avg(score) FROM shop)