SelectWithUnionQuery (children 1)
 ExpressionList (children 1)
  SelectQuery (children 3)
   ExpressionList (children 1)
    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 2)
    TablesInSelectQueryElement (children 1)
     TableExpression (children 1)
      TableIdentifier lineitem
    TablesInSelectQueryElement (children 2)
     TableExpression (children 1)
      TableIdentifier part
     TableJoin
   Function or (children 1)
    ExpressionList (children 3)
     Function and (children 1)
      ExpressionList (children 8)
       Function equals (children 1)
        ExpressionList (children 2)
         Identifier p_partkey
         Identifier l_partkey
       Function equals (children 1)
        ExpressionList (children 2)
         Identifier p_brand
         Literal \'Brand#12\'
       Function in (children 1)
        ExpressionList (children 2)
         Identifier p_container
         Literal Tuple_(\'SM CASE\', \'SM BOX\', \'SM PACK\', \'SM PKG\')
       Function greaterOrEquals (children 1)
        ExpressionList (children 2)
         Identifier l_quantity
         Literal UInt64_1
       Function lessOrEquals (children 1)
        ExpressionList (children 2)
         Identifier l_quantity
         Function plus (children 1)
          ExpressionList (children 2)
           Literal UInt64_1
           Literal UInt64_10
       Function and (children 1)
        ExpressionList (children 2)
         Function greaterOrEquals (children 1)
          ExpressionList (children 2)
           Identifier p_size
           Literal UInt64_1
         Function lessOrEquals (children 1)
          ExpressionList (children 2)
           Identifier p_size
           Literal UInt64_5
       Function in (children 1)
        ExpressionList (children 2)
         Identifier l_shipmode
         Literal Tuple_(\'AIR\', \'AIR REG\')
       Function equals (children 1)
        ExpressionList (children 2)
         Identifier l_shipinstruct
         Literal \'DELIVER IN PERSON\'
     Function and (children 1)
      ExpressionList (children 8)
       Function equals (children 1)
        ExpressionList (children 2)
         Identifier p_partkey
         Identifier l_partkey
       Function equals (children 1)
        ExpressionList (children 2)
         Identifier p_brand
         Literal \'Brand#23\'
       Function in (children 1)
        ExpressionList (children 2)
         Identifier p_container
         Literal Tuple_(\'MED BAG\', \'MED BOX\', \'MED PKG\', \'MED PACK\')
       Function greaterOrEquals (children 1)
        ExpressionList (children 2)
         Identifier l_quantity
         Literal UInt64_10
       Function lessOrEquals (children 1)
        ExpressionList (children 2)
         Identifier l_quantity
         Function plus (children 1)
          ExpressionList (children 2)
           Literal UInt64_10
           Literal UInt64_10
       Function and (children 1)
        ExpressionList (children 2)
         Function greaterOrEquals (children 1)
          ExpressionList (children 2)
           Identifier p_size
           Literal UInt64_1
         Function lessOrEquals (children 1)
          ExpressionList (children 2)
           Identifier p_size
           Literal UInt64_10
       Function in (children 1)
        ExpressionList (children 2)
         Identifier l_shipmode
         Literal Tuple_(\'AIR\', \'AIR REG\')
       Function equals (children 1)
        ExpressionList (children 2)
         Identifier l_shipinstruct
         Literal \'DELIVER IN PERSON\'
     Function and (children 1)
      ExpressionList (children 8)
       Function equals (children 1)
        ExpressionList (children 2)
         Identifier p_partkey
         Identifier l_partkey
       Function equals (children 1)
        ExpressionList (children 2)
         Identifier p_brand
         Literal \'Brand#34\'
       Function in (children 1)
        ExpressionList (children 2)
         Identifier p_container
         Literal Tuple_(\'LG CASE\', \'LG BOX\', \'LG PACK\', \'LG PKG\')
       Function greaterOrEquals (children 1)
        ExpressionList (children 2)
         Identifier l_quantity
         Literal UInt64_20
       Function lessOrEquals (children 1)
        ExpressionList (children 2)
         Identifier l_quantity
         Function plus (children 1)
          ExpressionList (children 2)
           Literal UInt64_20
           Literal UInt64_10
       Function and (children 1)
        ExpressionList (children 2)
         Function greaterOrEquals (children 1)
          ExpressionList (children 2)
           Identifier p_size
           Literal UInt64_1
         Function lessOrEquals (children 1)
          ExpressionList (children 2)
           Identifier p_size
           Literal UInt64_15
       Function in (children 1)
        ExpressionList (children 2)
         Identifier l_shipmode
         Literal Tuple_(\'AIR\', \'AIR REG\')
       Function equals (children 1)
        ExpressionList (children 2)
         Identifier l_shipinstruct
         Literal \'DELIVER IN PERSON\'