SelectWithUnionQuery (children 1)
 ExpressionList (children 1)
  SelectQuery (children 4)
   ExpressionList (children 5)
    Identifier s_suppkey
    Identifier s_name
    Identifier s_address
    Identifier s_phone
    Identifier total_revenue
   TablesInSelectQuery (children 2)
    TablesInSelectQueryElement (children 1)
     TableExpression (children 1)
      TableIdentifier supplier
    TablesInSelectQueryElement (children 2)
     TableExpression (children 1)
      TableIdentifier revenue0
     TableJoin
   Function and (children 1)
    ExpressionList (children 2)
     Function equals (children 1)
      ExpressionList (children 2)
       Identifier s_suppkey
       Identifier supplier_no
     Function equals (children 1)
      ExpressionList (children 2)
       Identifier total_revenue
       Subquery (children 1)
        SelectWithUnionQuery (children 1)
         ExpressionList (children 1)
          SelectQuery (children 2)
           ExpressionList (children 1)
            Function max (children 1)
             ExpressionList (children 1)
              Identifier total_revenue
           TablesInSelectQuery (children 1)
            TablesInSelectQueryElement (children 1)
             TableExpression (children 1)
              TableIdentifier revenue0
   ExpressionList (children 1)
    OrderByElement (children 1)
     Identifier s_suppkey