How many users are there?
select count(*) from user_profiles
Show their names.
select name from user_profiles
Please also show the 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