human
Schema:
accounts (custid, name)
savings (custid, balance)
checking (custid, balance)
Please answer with SQL.
assistant
Sure, I understand.
human
Find the saving balance of the account with the highest checking balance.
assistant
SELECT T3.balance FROM accounts AS T1 JOIN checking AS T2 ON T1.custid = T2.custid JOIN savings AS T3 ON T1.custid = T3.custid ORDER BY T2.balance DESC LIMIT 1
human
Find the name of account that has the lowest total checking and saving balance.
assistant
SELECT T1.name FROM accounts AS T1 JOIN checking AS T2 ON T1.custid = T2.custid JOIN savings AS T3 ON T1.custid = T3.custid ORDER BY T2.balance + T3.balance LIMIT 1
human
Find the name of accounts whose checking balance is below the average checking balance.
assistant
SELECT T1.name FROM accounts AS T1 JOIN checking AS T2 ON T1.custid = T2.custid WHERE T2.balance < (SELECT avg(balance) FROM checking)
human
How many accounts have a savings balance above the average savings balance?
assistant
SELECT count(*) FROM savings WHERE balance > (SELECT avg(balance) FROM savings)
human
What is the total checking balance in all accounts?
assistant
SELECT sum(balance) FROM checking
human
What is the average balance in checking accounts?
assistant
SELECT avg ( balance ) FROM checking ;