Which users had some tweets?
select name from user_profiles where uid in ( select uid from tweets )
Can you find me the average number of followers for these users?
select avg ( followers ) from user_profiles where uid in ( select uid from tweets )