SelectWithUnionQuery (children 1)
 ExpressionList (children 1)
  SelectQuery (children 5)
   ExpressionList (children 2)
    Identifier s_name
    Identifier s_address
   TablesInSelectQuery (children 2)
    TablesInSelectQueryElement (children 1)
     TableExpression (children 1)
      TableIdentifier supplier
    TablesInSelectQueryElement (children 2)
     TableExpression (children 1)
      TableIdentifier nation
     TableJoin
   Function and (children 1)
    ExpressionList (children 3)
     Function in (children 1)
      ExpressionList (children 2)
       Identifier s_suppkey
       Subquery (children 1)
        SelectWithUnionQuery (children 1)
         ExpressionList (children 1)
          SelectQuery (children 3)
           ExpressionList (children 1)
            Identifier ps_suppkey
           TablesInSelectQuery (children 1)
            TablesInSelectQueryElement (children 1)
             TableExpression (children 1)
              TableIdentifier partsupp
           Function and (children 1)
            ExpressionList (children 2)
             Function in (children 1)
              ExpressionList (children 2)
               Identifier ps_partkey
               Subquery (children 1)
                SelectWithUnionQuery (children 1)
                 ExpressionList (children 1)
                  SelectQuery (children 3)
                   ExpressionList (children 1)
                    Identifier p_partkey
                   TablesInSelectQuery (children 1)
                    TablesInSelectQueryElement (children 1)
                     TableExpression (children 1)
                      TableIdentifier part
                   Function like (children 1)
                    ExpressionList (children 2)
                     Identifier p_name
                     Literal \'forest%\'
             Function greater (children 1)
              ExpressionList (children 2)
               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)
                      Literal Float64_0.5
                      Function sum (children 1)
                       ExpressionList (children 1)
                        Identifier l_quantity
                   TablesInSelectQuery (children 1)
                    TablesInSelectQueryElement (children 1)
                     TableExpression (children 1)
                      TableIdentifier lineitem
                   Function and (children 1)
                    ExpressionList (children 4)
                     Function equals (children 1)
                      ExpressionList (children 2)
                       Identifier l_partkey
                       Identifier ps_partkey
                     Function equals (children 1)
                      ExpressionList (children 2)
                       Identifier l_suppkey
                       Identifier ps_suppkey
                     Function greaterOrEquals (children 1)
                      ExpressionList (children 2)
                       Identifier l_shipdate
                       Function toDate (children 1)
                        ExpressionList (children 1)
                         Literal \'1994-01-01\'
                     Function less (children 1)
                      ExpressionList (children 2)
                       Identifier l_shipdate
                       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\'
     Function equals (children 1)
      ExpressionList (children 2)
       Identifier s_nationkey
       Identifier n_nationkey
     Function equals (children 1)
      ExpressionList (children 2)
       Identifier n_name
       Literal \'CANADA\'
   ExpressionList (children 1)
    OrderByElement (children 1)
     Identifier s_name
   Set
