human
Schema:
accounts (custid, name)
savings (custid, balance)
checking (custid, balance)
Please answer with SQL.
assistant
Sure, I understand.
human
What is the highest balance?
assistant
SELECT MAX( balance ) FROM savings;
human
How about the lowest?
assistant
SELECT MIN( balance ) FROM savings;
human
List all the people with accounts
assistant
SELECT name FROM ACCOUNTS ;