Comcast Interview Question

what is the order of operations on a sql query