Cotiviti interview question

In which order SQL queries are executed?