Find the average number of followers for the users who do not have any tweet.
SELECT avg(followers) FROM user_profiles WHERE UID NOT IN (SELECT UID FROM tweets)
average number of followers for users who do not have any tweet refers to AVG(followers) where there are no tweets associated with the user;"