CREATE TABLE bank (branch_id NUMBER, bname CLOB, no_of_customers NUMBER, city CLOB, state CLOB)
CREATE TABLE customer (cust_id CLOB, cust_name CLOB, acc_type CLOB, acc_bal NUMBER, no_of_loans NUMBER, credit_score NUMBER, branch_id NUMBER, state CLOB)
CREATE TABLE loan (loan_id CLOB, loan_type CLOB, cust_id CLOB, branch_id CLOB, amount NUMBER)

What are the names of customers who have taken both Mortgage and Auto loans?
SELECT T1.cust_name FROM customer AS T1 JOIN loan AS T2 ON T1.cust_id = T2.cust_id WHERE loan_type = 'Mortgages' INTERSECT SELECT T1.cust_name FROM customer AS T1 JOIN loan AS T2 ON T1.cust_id = T2.cust_id WHERE loan_type = 'Auto'
SELECT "T1"."cust_name" FROM "customer" "T1" JOIN "loan" "T2" ON "T1"."cust_id" = "T2"."cust_id" WHERE "loan_type" = 'Mortgages' INTERSECT SELECT "T1"."cust_name" FROM "customer" "T1" JOIN "loan" "T2" ON "T1"."cust_id" = "T2"."cust_id" WHERE "loan_type" = 'Auto'