-- 1. Total number of customers
SELECT COUNT(*) FROM CUSTOMER;

-- 2. Total balance of all accounts in the bank
SELECT SUM(BALANCE) FROM ACCOUNT_TYPE;

-- 3. Number of operations for all accounts in the bank
SELECT COUNT(*) FROM ACCOUNT_ACTIVITY;

-- 1 for All Checking Accounts
-- Use 'S' for savings
SELECT COUNT(*) FROM ACCOUNT_TYPE
WHERE ACCOUNT_TYPE = 'C';

-- 2 Total balance of all checking accounts in the bank
-- Use 'S' for savings
SELECT SUM(BALANCE) FROM ACCOUNT_TYPE
WHERE ACCOUNT_TYPE = 'C';

-- 3 Number of operations for all checking accounts in the bank
-- Use 'S' for savings
SELECT COUNT(*) FROM ACCOUNT_ACTIVITY
WHERE ACCOUNT_TYPE = 'C';

-- 1 Total number of customers rolled up by state
SELECT STATE, COUNT(*) FROM CUSTOMER
GROUP BY STATE;

-- 2 Total balance of all customers in the bank rolled up by state
SELECT STATE, SUM(BALANCE)
FROM CUSTOMER C, ACCOUNT_TYPE A
WHERE C.CUSTOMER_NUM = A.CUSTOMER_NUM
GROUP BY STATE;

-- 3 Number of operations for all customers in the bank rolled up by state
SELECT STATE, COUNT(*)
FROM CUSTOMER, ACCOUNT_ACTIVITY
WHERE CUSTOMER.CUSTOMER_NUM = ACCOUNT_ACTIVITY.CUSTOMER_NUM
GROUP BY STATE;