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)

List the text of all tweets in the order of date.
SELECT text FROM tweets ORDER BY createdate
SELECT "text" FROM "tweets" ORDER BY "createdate"