Pregunta de entrevista de Chamberlain Group

How SQL proceed with it's logic