CREATE TABLE tweets (followers INT, UID VARCHAR)
CREATE TABLE user_profiles (followers INT, UID VARCHAR)

Find the average number of followers for the users who do not have any tweet.
SELECT AVG(followers) FROM user_profiles WHERE NOT UID IN (SELECT UID FROM tweets)
SELECT AVG("followers") FROM "user_profiles" WHERE NOT "UID" IN (SELECT "UID" FROM "tweets")