CREATE TABLE user_profiles (followers NUMBER, UID VARCHAR2)
CREATE TABLE tweets (followers NUMBER, UID VARCHAR2)

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)
SELECT AVG("followers") FROM "user_profiles" WHERE "UID" IN (SELECT "UID" FROM "tweets")