e6data Interview Question

how does sql code run need to explain about the order