(5) select (5-2) distinct (5-3) top (top_specification>) (5-1) select_list> (1) from (1-j) left_table> join_type> join right_table> on on_predicate> |(1-a) left_table> apply_type> apply right_table_expression> as alias> |(1-p) left_table> pivot (pivot_specification>) as alias> |(1-u) left_table> unpivot (unpivot_specification>) as alias> (2) where where_predicate> (3) group by group_by_specification> (4) having having_predicate> (6) order by order_by_list>
