CREATE TABLE shop (shop_id VARCHAR, address VARCHAR, score INT)

Find the id and address of the shops whose score is below the average score.
SELECT shop_id, address FROM shop WHERE score < (SELECT AVG(score) FROM shop)
SELECT "shop_id", "address" FROM "shop" WHERE "score" < (SELECT AVG("score") FROM "shop")