SelectWithUnionQuery (children 1) ExpressionList (children 1) SelectQuery (children 5) ExpressionList (children 2) Identifier n_name Function sum (alias revenue) (children 1) ExpressionList (children 1) Function multiply (children 1) ExpressionList (children 2) Identifier l_extendedprice Function minus (children 1) ExpressionList (children 2) Literal UInt64_1 Identifier l_discount TablesInSelectQuery (children 6) TablesInSelectQueryElement (children 1) TableExpression (children 1) TableIdentifier customer TablesInSelectQueryElement (children 2) TableExpression (children 1) TableIdentifier orders TableJoin TablesInSelectQueryElement (children 2) TableExpression (children 1) TableIdentifier lineitem TableJoin TablesInSelectQueryElement (children 2) TableExpression (children 1) TableIdentifier supplier TableJoin TablesInSelectQueryElement (children 2) TableExpression (children 1) TableIdentifier nation TableJoin TablesInSelectQueryElement (children 2) TableExpression (children 1) TableIdentifier region TableJoin Function and (children 1) ExpressionList (children 9) Function equals (children 1) ExpressionList (children 2) Identifier c_custkey Identifier o_custkey Function equals (children 1) ExpressionList (children 2) Identifier l_orderkey Identifier o_orderkey Function equals (children 1) ExpressionList (children 2) Identifier l_suppkey Identifier s_suppkey Function equals (children 1) ExpressionList (children 2) Identifier c_nationkey Identifier s_nationkey Function equals (children 1) ExpressionList (children 2) Identifier s_nationkey Identifier n_nationkey Function equals (children 1) ExpressionList (children 2) Identifier n_regionkey Identifier r_regionkey Function equals (children 1) ExpressionList (children 2) Identifier r_name Literal \'ASIA\' Function greaterOrEquals (children 1) ExpressionList (children 2) Identifier o_orderdate Function toDate (children 1) ExpressionList (children 1) Literal \'1994-01-01\' Function less (children 1) ExpressionList (children 2) Identifier o_orderdate Function plus (children 1) ExpressionList (children 2) Function toDate (children 1) ExpressionList (children 1) Literal \'1994-01-01\' Function toIntervalYear (children 1) ExpressionList (children 1) Literal \'1\' ExpressionList (children 1) Identifier n_name ExpressionList (children 1) OrderByElement (children 1) Identifier revenue