human
Schema:
accounts (custid, name)
savings (custid, balance)
checking (custid, balance)
Please answer with SQL.
assistant
Sure, I understand.
human
How many accounts are there in the bank?
assistant
SELECT COUNT( * ) FROM accounts;
human
What are the names for each?
assistant
SELECT name FROM accounts ;