[result]

TOP-N (order by [[1: S_SUPPKEY ASC NULLS FIRST]])

TOP-N (order by [[1: S_SUPPKEY ASC NULLS FIRST]])

INNER JOIN (join-predicate [1: S_SUPPKEY = 11: L_SUPPKEY] post-join-predicate [null])

SCAN (columns[1: S_SUPPKEY, 2: S_NAME, 3: S_ADDRESS, 5: S_PHONE] predicate[null])

EXCHANGE SHUFFLE[11]

INNER JOIN (join-predicate [27: sum = 47: max] post-join-predicate [null])

AGGREGATE ([GLOBAL] aggregate [{27: sum=sum(27: sum)}] group by [[11: L_SUPPKEY]] having [27: sum IS NOT NULL]

EXCHANGE SHUFFLE[11]

AGGREGATE ([LOCAL] aggregate [{27: sum=sum(26: expr)}] group by [[11: L_SUPPKEY]] having [null]

SCAN (columns[19: L_SHIPDATE, 11: L_SUPPKEY, 14: L_EXTENDEDPRICE, 15: L_DISCOUNT] predicate[19: L_SHIPDATE >= 1995-07-01 AND 19: L_SHIPDATE < 1995-10-01])

EXCHANGE BROADCAST

AGGREGATE ([GLOBAL] aggregate [{47: max=max(47: max)}] group by [[]] having [47: max IS NOT NULL]

EXCHANGE GATHER

AGGREGATE ([LOCAL] aggregate [{47: max=max(46: sum)}] group by [[]] having [null]

AGGREGATE ([GLOBAL] aggregate [{46: sum=sum(46: sum)}] group by [[30: L_SUPPKEY]] having [null]

EXCHANGE SHUFFLE[30]

AGGREGATE ([LOCAL] aggregate [{46: sum=sum(45: expr)}] group by [[30: L_SUPPKEY]] having [null]

SCAN (columns[33: L_EXTENDEDPRICE, 34: L_DISCOUNT, 38: L_SHIPDATE, 30: L_SUPPKEY] predicate[38: L_SHIPDATE >= 1995-07-01 AND 38: L_SHIPDATE < 1995-10-01])

[end]