Capgemini interview question

Write few SQL queries...