The user who tweeted more than once
select * from user_profiles as t1 join tweets as t2 on t1.uid = t2.uid group by t2.uid having count ( * ) > 1
Yes
select t1.name, t2.text from user_profiles as t1 join tweets as t2 on t1.uid = t2.uid group by t2.uid having count ( * ) > 1
How many tweets did Iron man tweet?
select count ( * ) from user_profiles as t1 join tweets as t2 on t1.uid = t2.uid and t1.name = 'Iron Man'
What about Celine?
select count ( * ) from user_profiles as t1 join tweets as t2 on t1.uid = t2.uid and t1.name = 'Celine Dion'