how many loans have an amount greater than 3000?
select count(*) from loan where amount > 3000
what are their types?
select distinct loan_type from loan where amount > 3000
Find the names of the customers who own these loans.
select t1.cust_name from customer as t1 join loan as t2 on t1.cust_id = t2.cust_id where amount > 3000