How many followers does the user named "Tyler Swift" have?
select count(*) from user_profiles as t1 join follows as t2 on t1.uid = t2.f1 where t1.name = 'Tyler Swift'
How many users are there whose number of followers is greater than that of the user named "Tyler Swift"?
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(*) > (select count(*) from user_profiles as t1 join follows as t2 on t1.uid = t2.f1 where t1.name = 'Tyler Swift'))
Show the names of these users.
select t1.name from user_profiles as t1 join follows as t2 on t1.uid = t2.f1 group by t2.f1 having count(*) > (select count(*) from user_profiles as t1 join follows as t2 on t1.uid = t2.f1 where t1.name = 'Tyler Swift')