CREATE TABLE checking (custid NUMBER, balance NUMBER)
CREATE TABLE accounts (custid NUMBER, name CLOB)
CREATE TABLE savings (custid NUMBER, balance NUMBER)

Find the number of accounts with a savings balance that is higher than the average savings balance.
SELECT COUNT(*) FROM savings WHERE balance > (SELECT AVG(balance) FROM savings)
SELECT COUNT(*) FROM "savings" WHERE "balance" > (SELECT AVG("balance") FROM "savings")