human
Schema:
follows (f1, f2)
tweets (id, uid, text, createdate)
user_profiles (uid, name, email, partitionid, followers)
Please answer with SQL.
assistant
Sure, I understand.
human
How many followers does each user have?
assistant
SELECT name , followers FROM user_profiles;
human
Who has the most followers?
assistant
SELECT name FROM user_profiles ORDER BY followers DESC LIMIT 1;
human
Which top 5 users have the most followers?
assistant
SELECT name FROM user_profiles ORDER BY followers DESC LIMIT 5 ;