CREATE TABLE follows (f1 INT, f2 INT)
CREATE TABLE tweets (id BIGINT, uid INT, text CHAR, createdate DATETIME)
CREATE TABLE user_profiles (uid INT, name VARCHAR, email VARCHAR, partitionid INT, followers INT)

Find the name and partition id for users who tweeted less than twice Show bar chart, and could you sort by the total number in ascending?
SELECT name, partitionid FROM user_profiles AS T1 JOIN tweets AS T2 ON T1.uid = T2.uid ORDER BY partitionid
SELECT "name", "partitionid" FROM "user_profiles" AS "T1" JOIN "tweets" AS "T2" ON "T1"."uid" = "T2"."uid" ORDER BY "partitionid" NULLS FIRST