CREATE TABLE follows (f1 DECIMAL, f2 DECIMAL)
CREATE TABLE tweets (id DECIMAL, uid DECIMAL, text TEXT, createdate TIME)
CREATE TABLE user_profiles (uid DECIMAL, name TEXT, email TEXT, partitionid DECIMAL, followers DECIMAL)

Find the number of followers for each user.
SELECT COUNT(*) FROM follows GROUP BY f1
SELECT COUNT(*) FROM "follows" GROUP BY "f1"