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)
CREATE TABLE follows (f1 NUMBER, f2 NUMBER)

Find the number of users who posted some tweets.
SELECT COUNT(DISTINCT uid) FROM tweets
SELECT COUNT(DISTINCT "uid") FROM "tweets"