Whose savings balance is lower than their checking balance?
select t1.name from accounts as t1 join checking as t2 on t1.custid = t2.custid join savings as t3 on t1.custid = t3.custid where t3.balance < t2.balance
What is the total balance of "Weeks" Checking and savings.
select t3.balance + t2.balance from accounts as t1 join checking as t2 on t1.custid = t2.custid join savings as t3 on t1.custid = t3.custid where t1.name = "Weeks"
yes, Weeks' ID, please.
select custid from accounts where name = "Weeks"