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

Find the name of each user and number of tweets tweeted by each of them Visualize by bar chart, and rank in descending by the x-axis.
SELECT name, COUNT(*) FROM user_profiles AS T1 JOIN tweets AS T2 ON T1.uid = T2.uid GROUP BY T2.uid ORDER BY name DESC
SELECT "name", COUNT(*) FROM "user_profiles" "T1" JOIN "tweets" "T2" ON "T1"."uid" = "T2"."uid" GROUP BY "T2"."uid" ORDER BY "name" DESC