Who has the least number of followers?
select name from user_profiles order by followers limit 1
How many users have more than one follower?
select count(*) from (select t1.name from user_profiles as t1 join follows as t2 on t1.uid = t2.f1 group by t2.f1 having count(*) > 1)
Show their names and emails.
select t1.name, t1.email from user_profiles as t1 join follows as t2 on t1.uid = t2.f1 group by t2.f1 having count(*) > 1