CREATE TABLE user_profiles (name VARCHAR2, uid VARCHAR2)
CREATE TABLE tweets (uid VARCHAR2)

Find the names of users who have more than one tweet.
SELECT T1.name FROM user_profiles AS T1 JOIN tweets AS T2 ON T1.uid = T2.uid GROUP BY T2.uid HAVING COUNT(*) > 1
SELECT "T1"."name" FROM "user_profiles" "T1" JOIN "tweets" "T2" ON "T1"."uid" = "T2"."uid" GROUP BY "T2"."uid" HAVING COUNT(*) > 1