SelectWithUnionQuery (children 1) ExpressionList (children 1) SelectQuery (children 6) ExpressionList (children 2) Identifier ps_partkey Function sum (alias value) (children 1) ExpressionList (children 1) Function multiply (children 1) ExpressionList (children 2) Identifier ps_supplycost Identifier ps_availqty TablesInSelectQuery (children 3) TablesInSelectQueryElement (children 1) TableExpression (children 1) TableIdentifier partsupp TablesInSelectQueryElement (children 2) TableExpression (children 1) TableIdentifier supplier TableJoin TablesInSelectQueryElement (children 2) TableExpression (children 1) TableIdentifier nation TableJoin Function and (children 1) ExpressionList (children 3) Function equals (children 1) ExpressionList (children 2) Identifier ps_suppkey Identifier s_suppkey Function equals (children 1) ExpressionList (children 2) Identifier s_nationkey Identifier n_nationkey Function equals (children 1) ExpressionList (children 2) Identifier n_name Literal \'GERMANY\' ExpressionList (children 1) Identifier ps_partkey Function greater (children 1) ExpressionList (children 2) Function sum (children 1) ExpressionList (children 1) Function multiply (children 1) ExpressionList (children 2) Identifier ps_supplycost Identifier ps_availqty Subquery (children 1) SelectWithUnionQuery (children 1) ExpressionList (children 1) SelectQuery (children 3) ExpressionList (children 1) Function multiply (children 1) ExpressionList (children 2) Function sum (children 1) ExpressionList (children 1) Function multiply (children 1) ExpressionList (children 2) Identifier ps_supplycost Identifier ps_availqty Function toDecimal64 (children 1) ExpressionList (children 2) Literal \'0.0100000000\' Literal UInt64_2 TablesInSelectQuery (children 3) TablesInSelectQueryElement (children 1) TableExpression (children 1) TableIdentifier partsupp TablesInSelectQueryElement (children 2) TableExpression (children 1) TableIdentifier supplier TableJoin TablesInSelectQueryElement (children 2) TableExpression (children 1) TableIdentifier nation TableJoin Function and (children 1) ExpressionList (children 3) Function equals (children 1) ExpressionList (children 2) Identifier ps_suppkey Identifier s_suppkey Function equals (children 1) ExpressionList (children 2) Identifier s_nationkey Identifier n_nationkey Function equals (children 1) ExpressionList (children 2) Identifier n_name Literal \'GERMANY\' ExpressionList (children 1) OrderByElement (children 1) Identifier value