ORIX USA interview question

SQL execution question about how are queries executed