human
Schema:
bank (branch_ID, bname, no_of_customers, city, state)
customer (cust_ID, cust_name, acc_type, acc_bal, no_of_loans, credit_score, branch_ID, state)
loan (loan_ID, loan_type, cust_ID, branch_ID, amount)
Please answer with SQL.
assistant
Sure, I understand.
human
Thanks! I'm a bit short on time, so can you provide me with Owens loan amount?
assistant
SELECT t2.amount FROM loan AS T2 JOIN customer AS T1 ON T1.cust_id = T2.cust_id WHERE t1.cust_name = "Owen" ;