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

Count the number of accounts.
SELECT COUNT(*) FROM accounts
SELECT COUNT(*) FROM "accounts"