Capgemini interview question

types of subqueries in sql.