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"
text tweet refers to T2.text; for a specific user (Iron Man) involves JOINing user_profiles and tweets tables and filtering where T1.name = 'Iron Man';