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

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