SELECT T1.name ,  count(*) FROM user_profiles AS T1 JOIN tweets AS T2 ON T1.uid  =  T2.uid GROUP BY T2.uid
Find the name of each user and number of tweets tweeted by each of them.
SELECT T1.name , count ( * ) FROM user_profiles AS T1 JOIN tweets AS T2 ON T1.uid = T2.uid GROUP BY T2.uid
select t1 . name , count ( * ) from user_profiles as t1 join tweets as t2 on t1 . uid = t2 . uid group by t2 . uid
Find the name of each user and number of tweets tweeted by each of them .