hi. I would like to know how many users are followed by Mary?
select count ( t2.f1 ) from user_profiles as t1 join follows as t2 on t1.uid = t2.f2 where t1.name = "Mary"
and how many are followed by Susan?
select count ( t2.f1 ) from user_profiles as t1 join follows as t2 on t1.uid = t2.f2 where t1.name = "Susan"
can you tell me the Id of these users?
select t2.f1 from user_profiles as t1 join follows as t2 on t1.uid = t2.f2 where t1.name = "Susan"
and the user id followed by Mary?
select t2.f1 from user_profiles as t1 join follows as t2 on t1.uid = t2.f2 where t1.name = "Susan" or t1.name = "Mary"