SELECT avg(followers) FROM user_profiles WHERE UID NOT IN (SELECT UID FROM tweets)
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 )
select avg ( followers ) from user_profiles where uid not in ( select uid from tweets )
Find the average number of followers for the users who do not have any tweet .