Pergunta de entrevista da empresa Accenture

Explain me the sequence in which SQL complies code