what states are the customers from?
select distinct state from customer
For each state, how many customers have a credit score above 100?
select count(*), state from customer where credit_score > 100 group by state
find their total account balances.
select sum(acc_bal), state from customer where credit_score > 100 group by state