How many users have some tweets?
select count(*) from user_profiles where uid in (select uid from tweets)
Show the name of these users and their number of followers.
select name, followers from user_profiles where uid in (select uid from tweets)
What is the average number of followers for these users?
select avg(followers) from user_profiles where uid in (select uid from tweets)