which states are the customers from?
select distinct state from customer
find the names of customers from Utah or Texas.
select cust_name from customer where state = 'Utah' or state = 'Texas'
what is their total account balance?
select sum(acc_bal) from customer where state = 'Utah' or state = 'Texas'