Pregunta de entrevista de Accenture

Explain me the sequence in which SQL complies code