How many accounts have a savings balance above the average savings balance?
CREATE TABLE savings (balance INTEGER)
SELECT COUNT(*) FROM savings WHERE balance > (SELECT AVG(balance) FROM savings)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE savings (balance INTEGER) Question: How many accounts have a savings balance above the average savings balance? [/INST] SELECT COUNT(*) FROM savings WHERE balance > (SELECT AVG(balance) FROM savings) </s>