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

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