CREATE TABLE customer (cust_name VARCHAR, acc_type VARCHAR, cust_id VARCHAR)
CREATE TABLE loan (cust_id VARCHAR, amount INT)

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") > 5000