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)

Find the name and partition id for users who tweeted less than twice.
SELECT T1.name, T1.partitionid FROM user_profiles AS T1 JOIN tweets AS T2 ON T1.uid = T2.uid GROUP BY T2.uid HAVING COUNT(*) < 2
SELECT "T1"."name", "T1"."partitionid" FROM "user_profiles" "T1" JOIN "tweets" "T2" ON "T1"."uid" = "T2"."uid" GROUP BY "T2"."uid" HAVING COUNT(*) < 2