Infosys Interview Question

Do you know sql? Asked structure of select statement.Gave me two tables asked me to write a nested query.