SelectWithUnionQuery (children 1)
 ExpressionList (children 1)
  SelectQuery (children 3)
   ExpressionList (children 2)
    WithElement (children 1)
     Subquery (children 1)
      SelectWithUnionQuery (children 1)
       ExpressionList (children 1)
        SelectQuery (children 3)
         ExpressionList (children 1)
          Identifier address.email_address
         TablesInSelectQuery (children 1)
          TablesInSelectQueryElement (children 1)
           TableExpression (children 1)
            TableIdentifier address
         ExpressionList (children 1)
          Identifier address.email_address
    WithElement (children 1)
     Subquery (children 1)
      SelectWithUnionQuery (children 1)
       ExpressionList (children 1)
        SelectQuery (children 1)
         ExpressionList (children 2)
          Subquery (alias num_clicks) (children 1)
           SelectWithUnionQuery (children 1)
            ExpressionList (children 1)
             SelectQuery (children 2)
              ExpressionList (children 1)
               Function COUNT (children 1)
                ExpressionList (children 1)
                 Asterisk
              TablesInSelectQuery (children 2)
               TablesInSelectQueryElement (children 1)
                TableExpression (children 1)
                 TableIdentifier fact_click
               TablesInSelectQueryElement (children 2)
                TableExpression (children 1)
                 TableIdentifier records
                TableJoin (children 1)
                 Function equals (children 1)
                  ExpressionList (children 2)
                   Identifier records.email_address
                   Identifier fact_click.email_address
          Subquery (alias num_records) (children 1)
           SelectWithUnionQuery (children 1)
            ExpressionList (children 1)
             SelectQuery (children 2)
              ExpressionList (children 1)
               Function COUNT (children 1)
                ExpressionList (children 1)
                 Asterisk
              TablesInSelectQuery (children 1)
               TablesInSelectQueryElement (children 1)
                TableExpression (children 1)
                 TableIdentifier records
   ExpressionList (children 1)
    Asterisk
   TablesInSelectQuery (children 1)
    TablesInSelectQueryElement (children 1)
     TableExpression (children 1)
      TableIdentifier stats
