text: CREATE TABLE follows (f1 VARCHAR); CREATE TABLE user_profiles (name VARCHAR, email VARCHAR, uid VARCHAR) -- Find the name and email for the users who have more than one follower. 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 CREATE TABLE tweets (uid VARCHAR); CREATE TABLE user_profiles (name VARCHAR, uid VARCHAR) -- Find the names of users who have more than one tweet. SELECT T1.name FROM user_profiles AS T1 JOIN tweets AS T2 ON T1.uid = T2.uid GROUP BY T2.uid HAVING COUNT(*) > 1 CREATE TABLE follows (f1 VARCHAR, f2 VARCHAR); CREATE TABLE user_profiles (uid VARCHAR, name VARCHAR) -- 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" CREATE TABLE follows (f1 VARCHAR, f2 VARCHAR); CREATE TABLE user_profiles (uid VARCHAR, name VARCHAR) -- Find the id of users who are followed by Mary or Susan. SELECT T2.f1 FROM user_profiles AS T1 JOIN follows AS T2 ON T1.uid = T2.f2 WHERE T1.name = "Mary" OR T1.name = "Susan" CREATE TABLE user_profiles (name VARCHAR, followers VARCHAR) -- Find the name of the user who has the largest number of followers. SELECT name FROM user_profiles ORDER BY followers DESC LIMIT 1 CREATE TABLE user_profiles (name VARCHAR, email VARCHAR, followers VARCHAR) -- Find the name and email of the user followed by the least number of people. SELECT name, email FROM user_profiles ORDER BY followers LIMIT 1