CREATE TABLE endowment (school_id VARCHAR, amount INT)

Find the number of schools that have more than one donator whose donation amount is less than 8.5.
SELECT COUNT(*) FROM (SELECT * FROM endowment WHERE amount > 8.5 GROUP BY school_id HAVING COUNT(*) > 1)
WITH "cte" AS (SELECT 1 AS "_" FROM "endowment" WHERE "amount" > 8.5 GROUP BY "school_id" HAVING COUNT(*) > 1) SELECT COUNT(*) FROM "cte" AS "cte"