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

How many followers does each user have?
SELECT COUNT(*) FROM follows
SELECT COUNT(*) FROM "follows"