what is the average of account balance?
select avg ( acc_bal ) from customer
can you show me a list of account type?
select distinct acc_type from customer
what is the average of credit score?
select avg ( credit_score ) from customer
find the total account balance of each customer from Utah or Texas
select sum ( acc_bal ) from customer where state = 'Utah' or state = 'Texas'