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
Find the name and account balance of the customers who have loans with a total amount of more than 5000.
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
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 ) > value
Find the name and account balance of the customers who have loans with a total amount of more than 5000 .