Find the average number of followers for the users who had some tweets.
select avg(followers) from user_profiles where uid in (select uid from tweets)