Find the average number of followers for the users who had some 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)
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Find the average number of followers for the users who had some tweets. ### Input: CREATE TABLE user_profiles (
    followers INTEGER,
    UID VARCHAR
)

CREATE TABLE tweets (
    followers INTEGER,
    UID VARCHAR
) ### Response: SELECT AVG(followers) FROM user_profiles WHERE UID IN (SELECT UID FROM tweets)