Database: loan_1
Question: What are the names and account balances for customers who have taken a total amount of more than 5000 in loans?
SQL:
SELECT T1.cust_name ,  T1.acc_type FROM customer AS T1 JOIN loan AS T2 ON T1.cust_id  =  T2.cust_id GROUP BY T1.cust_name HAVING sum(T2.amount)  >  5000