SELECT name, COUNT(*) FROM user_profiles AS T1 JOIN tweets AS T2 ON T1.uid = T2.uid GROUP BY T2.uid ORDER BY COUNT(*)
Find the name of each user and number of tweets tweeted by each of them Visualize by bar chart, and order Y-axis from low to high order please.
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)
)