What is Alice friend name?
select friend from personfriend where name = 'Alice'
How old is Alice friend?
select age from person as t1 where name = ( select friend from personfriend where name = 'Alice' )