text: CREATE TABLE follows (Id VARCHAR) -- How many followers does each user have? SELECT COUNT(*) FROM follows CREATE TABLE follows (f1 VARCHAR) -- Find the number of followers for each user. SELECT COUNT(*) FROM follows GROUP BY f1 CREATE TABLE tweets (Id VARCHAR) -- Find the number of tweets in record. SELECT COUNT(*) FROM tweets CREATE TABLE tweets (UID VARCHAR) -- Find the number of users who posted some tweets. SELECT COUNT(DISTINCT UID) FROM tweets CREATE TABLE user_profiles (name VARCHAR, email VARCHAR) -- Find the name and email of the user whose name contains the word ‘Swift’. SELECT name, email FROM user_profiles WHERE name LIKE '%Swift%' CREATE TABLE user_profiles (name VARCHAR, email VARCHAR) -- Find the names of users whose emails contain ‘superstar’ or ‘edu’. SELECT name FROM user_profiles WHERE email LIKE '%superstar%' OR email LIKE '%edu%' CREATE TABLE tweets (text VARCHAR) -- Return the text of tweets about the topic 'intern'. SELECT text FROM tweets WHERE text LIKE '%intern%' CREATE TABLE user_profiles (name VARCHAR, email VARCHAR, followers INTEGER) -- Find the name and email of the users who have more than 1000 followers. SELECT name, email FROM user_profiles WHERE followers > 1000 CREATE TABLE follows (f1 VARCHAR); CREATE TABLE user_profiles (name VARCHAR, uid VARCHAR) -- Find the names of the users whose number of followers is greater than that of the user named "Tyler Swift". 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')