Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE tweets ( id bigint(20), uid int(11), text char(140), createdate datetime )
TABLE: CREATE TABLE user_profiles ( uid int(11), name varchar(255), email varchar(255), partitionid int(11), followers int(11) )
TABLE: CREATE TABLE follows ( f1 int(11), f2 int(11) )

### Question ###
Find the name and partition id for users who tweeted less than twice Show bar chart, could you show by the name from high to low?

### Accurate SQL ###

SELECT name, partitionid FROM user_profiles AS T1 JOIN tweets AS T2 ON T1.uid = T2.uid ORDER BY name DESC