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

Find the name of each user and number of tweets tweeted by each of them Visualize by bar chart, and I want to list by the total number in desc.
SELECT name, COUNT(*) FROM user_profiles AS T1 JOIN tweets AS T2 ON T1.uid = T2.uid GROUP BY T2.uid ORDER BY COUNT(*) DESC
SELECT "name", COUNT(*) FROM "user_profiles" AS "T1" JOIN "tweets" AS "T2" ON "T1"."uid" = "T2"."uid" GROUP BY "T2"."uid" ORDER BY COUNT(*) DESC NULLS LAST