Show me all the users.
select name from user_profiles
Which of these users have more than one tweet?
select t1.name from user_profiles as t1 join tweets as t2 on t1.uid = t2.uid group by t2.uid having count ( * ) > 1
Show me the number of tweets for each of these users.
select t1.name, count ( * ) from user_profiles as t1 join tweets as t2 on t1.uid = t2.uid group by t2.uid having count ( * ) > 1