Is there an owner named Brown?
select * from accounts where name = "Brown"
What is his checking balance?
select t2.balance from accounts as t1 join checking as t2 on t1.custid = t2.custid where t1.name = 'Brown'
What is his savings balance?
select t2.balance from accounts as t1 join savings as t2 on t1.custid = t2.custid where t1.name = 'Brown'
Please show both at the same time.
select t2.balance, t3.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 = 'Brown'