Can you show all user ids that have more than 1 tweet?
select t1.uid from user_profiles as t1 join tweets as t2 on t1.uid = t2.uid group by t2.uid having count ( * ) > 1
Thanks, can you show the names associated with those user ids?
select t1.name from user_profiles as t1 join tweets as t2 on t1.uid = t2.uid group by t2.uid having count ( * ) > 1
Can you list the names in alphabetical order from top to bottom?
select t1.name from user_profiles as t1 join tweets as t2 on t1.uid = t2.uid group by t2.uid having count ( * ) > 1 order by t1.name