How many people are from Austin ?
select count ( * ) from person where city = "austin"
How many friends do Alice and Bob have combined ?
select count ( * ) from personfriend where name = "Alice" or name = "Bob"
Okay, so who has a friend in Austin ?
select name from personfriend where friend in ( select name from person where city = 'austin' )