Encontre o número médio de seguidores para os usuários que tiveram alguns tweets.
CREATE TABLE user_profiles (followers INTEGER, UID VARCHAR); CREATE TABLE tweets (followers INTEGER, UID VARCHAR)
SELECT AVG(followers) FROM user_profiles WHERE UID IN (SELECT UID FROM tweets)