Amazon Interview Question

basic SQL hierarchy of order execution