SELECT count(DISTINCT name) FROM PersonFriend WHERE friend NOT IN (SELECT name FROM person WHERE city  =  'Austin')
What is the total number of people who have no friends living in Austin?
SELECT count ( DISTINCT name ) FROM PersonFriend WHERE friend NOT IN ( SELECT name FROM person WHERE city = 'Austin ' )
select count ( distinct name ) from personfriend where friend not in ( select name from person where city = value )
What is the total number of people who have no friends living in Austin ?