Find the name and partition id for users who tweeted less than twice. Show bar chart.
CREATE TABLE follows (
    f1 int(11),
    f2 int(11)
)

CREATE TABLE tweets (
    id bigint(20),
    uid int(11),
    text char(140),
    createdate datetime
)

CREATE TABLE user_profiles (
    uid int(11),
    name varchar(255),
    email varchar(255),
    partitionid int(11),
    followers int(11)
)
SELECT name, partitionid FROM user_profiles AS T1 JOIN tweets AS T2 ON T1.uid = T2.uid
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Find the name and partition id for users who tweeted less than twice. Show bar chart. ### Input: CREATE TABLE follows (
    f1 int(11),
    f2 int(11)
)

CREATE TABLE tweets (
    id bigint(20),
    uid int(11),
    text char(140),
    createdate datetime
)

CREATE TABLE user_profiles (
    uid int(11),
    name varchar(255),
    email varchar(255),
    partitionid int(11),
    followers int(11)
) ### Response: SELECT name, partitionid FROM user_profiles AS T1 JOIN tweets AS T2 ON T1.uid = T2.uid