How many tweets in this table?
select count ( * ) from tweets
How many user profiles in this table?
select count ( * ) from user_profiles
What is the email id of Iron Man?
select email from user_profiles where name = "Iron Man"
What is the text tweet of Iron Man?
select t2.text from user_profiles as t1 join tweets as t2 on t1.uid = t2.uid where t1.name = "Iron Man"