Dye & Durham interview question

SQL execution sequence and other data anaylsis/engineer related question