Find the id and address of the shops whose score is below the average score.
CREATE TABLE shop (shop_id VARCHAR, address VARCHAR, score INTEGER)
SELECT shop_id, address FROM shop WHERE score < (SELECT AVG(score) FROM shop)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE shop (shop_id VARCHAR, address VARCHAR, score INTEGER) Question: Find the id and address of the shops whose score is below the average score. [/INST] SELECT shop_id, address FROM shop WHERE score < (SELECT AVG(score) FROM shop) </s>