show me the name of the users.
select name from user_profiles
yes
select * from user_profiles as t1 join tweets as t2 on t1.uid = t2.uid
show me the number of tweets of each user
select t1.name, count ( * ) from user_profiles as t1 join tweets as t2 on t1.uid = t2.uid group by t2.uid