what is the users' name?
select name from user_profiles
which one has the most followers?
select name from user_profiles order by followers desc limit 1
what is her email?
select email from user_profiles order by followers desc limit 1
find the id of users who are followed by mary and susan.
select t2.f1 from user_profiles as t1 join follows as t2 on t1.uid = t2.f2 where t1.name = "Mary" intersect select t2.f1 from user_profiles as t1 join follows as t2 on t1.uid = t2.f2 where t1.name = "Susan"