Find the number of schools that have more than one donator whose donation amount is less than 8.5.
CREATE TABLE endowment (school_id VARCHAR, amount INTEGER)
SELECT COUNT(*) FROM (SELECT * FROM endowment WHERE amount > 8.5 GROUP BY school_id HAVING COUNT(*) > 1)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE endowment (school_id VARCHAR, amount INTEGER) Question: Find the number of schools that have more than one donator whose donation amount is less than 8.5. [/INST] SELECT COUNT(*) FROM (SELECT * FROM endowment WHERE amount > 8.5 GROUP BY school_id HAVING COUNT(*) > 1) </s>