SelectWithUnionQuery (children 1)
 ExpressionList (children 1)
  SelectQuery (children 4)
   ExpressionList (children 1)
    Function divide (alias avg_yearly) (children 1)
     ExpressionList (children 2)
      Function sum (children 1)
       ExpressionList (children 1)
        Identifier l_extendedprice
      Literal Float64_7
   TablesInSelectQuery (children 2)
    TablesInSelectQueryElement (children 1)
     TableExpression (children 1)
      TableIdentifier lineitem
    TablesInSelectQueryElement (children 2)
     TableExpression (children 1)
      TableIdentifier part
     TableJoin
   Function and (children 1)
    ExpressionList (children 4)
     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 equals (children 1)
      ExpressionList (children 2)
       Identifier p_container
       Literal \'MED BOX\'
     Function less (children 1)
      ExpressionList (children 2)
       Identifier l_quantity
       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.2
              Function avg (children 1)
               ExpressionList (children 1)
                Identifier l_quantity
           TablesInSelectQuery (children 1)
            TablesInSelectQueryElement (children 1)
             TableExpression (children 1)
              TableIdentifier lineitem
           Function equals (children 1)
            ExpressionList (children 2)
             Identifier l_partkey
             Identifier p_partkey
   Set