e6data interview question

how does sql code run need to explain about the order