SelectWithUnionQuery (children 1)
 ExpressionList (children 1)
  SelectQuery (children 5)
   ExpressionList (children 2)
    Identifier v_date (alias vDate)
    Function round (alias v_sum) (children 1)
     ExpressionList (children 1)
      Function sum (children 1)
       ExpressionList (children 1)
        Identifier v_share
   TablesInSelectQuery (children 1)
    TablesInSelectQueryElement (children 1)
     TableExpression (children 1)
      Subquery (children 1)
       SelectWithUnionQuery (children 1)
        ExpressionList (children 1)
         SelectQuery (children 4)
          ExpressionList (children 6)
           Subquery (alias dummy_1) (children 1)
            SelectWithUnionQuery (children 1)
             ExpressionList (children 1)
              SelectQuery (children 1)
               ExpressionList (children 1)
                Function modulo (children 1)
                 ExpressionList (children 2)
                  Function rand (children 1)
                   ExpressionList
                  Literal UInt64_10000
           Subquery (alias dummy_2) (children 1)
            SelectWithUnionQuery (children 1)
             ExpressionList (children 1)
              SelectQuery (children 1)
               ExpressionList (children 1)
                Function modulo (children 1)
                 ExpressionList (children 2)
                  Function rand (children 1)
                   ExpressionList
                  Literal UInt64_10000
           Subquery (alias dummy_3) (children 1)
            SelectWithUnionQuery (children 1)
             ExpressionList (children 1)
              SelectQuery (children 1)
               ExpressionList (children 1)
                Function modulo (children 1)
                 ExpressionList (children 2)
                  Function rand (children 1)
                   ExpressionList
                  Literal UInt64_10000
           WithElement (children 1)
            Subquery (children 1)
             SelectWithUnionQuery (children 1)
              ExpressionList (children 1)
               SelectQuery (children 3)
                ExpressionList (children 2)
                 Function modulo (alias d_id) (children 1)
                  ExpressionList (children 2)
                   Function xxHash64 (children 1)
                    ExpressionList (children 1)
                     Function rand (children 1)
                      ExpressionList
                   Literal UInt64_100000
                 Function toDate (alias v_date) (children 1)
                  ExpressionList (children 1)
                   Function plus (children 1)
                    ExpressionList (children 2)
                     Function parseDateTimeBestEffort (children 1)
                      ExpressionList (children 1)
                       Literal \'2022-01-01\'
                     Function modulo (children 1)
                      ExpressionList (children 2)
                       Function rand (children 1)
                        ExpressionList
                       Literal UInt64_2600000
                TablesInSelectQuery (children 1)
                 TablesInSelectQueryElement (children 1)
                  TableExpression (children 1)
                   Function numbers (children 1)
                    ExpressionList (children 1)
                     Literal UInt64_1000000
                ExpressionList (children 1)
                 OrderByElement (children 1)
                  Identifier d_id
           WithElement (children 1)
            Subquery (children 1)
             SelectWithUnionQuery (children 1)
              ExpressionList (children 1)
               SelectQuery (children 2)
                ExpressionList (children 1)
                 Function modulo (alias d_id) (children 1)
                  ExpressionList (children 2)
                   Function xxHash64 (children 1)
                    ExpressionList (children 1)
                     Function rand (children 1)
                      ExpressionList
                   Literal UInt64_40000
                TablesInSelectQuery (children 1)
                 TablesInSelectQueryElement (children 1)
                  TableExpression (children 1)
                   Function numbers (children 1)
                    ExpressionList (children 1)
                     Literal UInt64_1000000
           WithElement (children 1)
            Subquery (children 1)
             SelectWithUnionQuery (children 1)
              ExpressionList (children 1)
               SelectQuery (children 3)
                ExpressionList (children 3)
                 Literal NULL (alias v_date)
                 Identifier d_id
                 Literal UInt64_0 (alias v_share)
                TablesInSelectQuery (children 1)
                 TablesInSelectQueryElement (children 1)
                  TableExpression (children 1)
                   TableIdentifier _i
                Literal UInt64_100
          ExpressionList (children 1)
           Asterisk
          TablesInSelectQuery (children 1)
           TablesInSelectQueryElement (children 1)
            TableExpression (children 1)
             Subquery (children 1)
              SelectWithUnionQuery (children 1)
               ExpressionList (children 2)
                SelectQuery (children 2)
                 ExpressionList (children 3)
                  Identifier d_id
                  Identifier v_date
                  Identifier v_share
                 TablesInSelectQuery (children 1)
                  TablesInSelectQueryElement (children 1)
                   TableExpression (children 1)
                    TableIdentifier not_i
                SelectQuery (children 2)
                 ExpressionList (children 3)
                  Identifier d_id
                  Identifier v_date
                  Literal UInt64_1 (alias v_share)
                 TablesInSelectQuery (children 1)
                  TablesInSelectQueryElement (children 1)
                   TableExpression (children 1)
                    Subquery (children 1)
                     SelectWithUnionQuery (children 1)
                      ExpressionList (children 1)
                       SelectQuery (children 3)
                        ExpressionList (children 2)
                         Identifier d_id
                         Function arrayJoin (alias v_date) (children 1)
                          ExpressionList (children 1)
                           Function groupArray (children 1)
                            ExpressionList (children 1)
                             Identifier v_date
                        TablesInSelectQuery (children 1)
                         TablesInSelectQueryElement (children 1)
                          TableExpression (children 1)
                           Subquery (children 1)
                            SelectWithUnionQuery (children 1)
                             ExpressionList (children 2)
                              SelectQuery (children 2)
                               ExpressionList (children 2)
                                Identifier v_date
                                Identifier d_id
                               TablesInSelectQuery (children 1)
                                TablesInSelectQueryElement (children 1)
                                 TableExpression (children 1)
                                  TableIdentifier _v
                              SelectQuery (children 2)
                               ExpressionList (children 2)
                                Literal NULL (alias v_date)
                                Identifier d_id
                               TablesInSelectQuery (children 1)
                                TablesInSelectQueryElement (children 1)
                                 TableExpression (children 1)
                                  TableIdentifier _i
                        ExpressionList (children 1)
                         Identifier d_id
          Function and (children 1)
           ExpressionList (children 2)
            Function greaterOrEquals (children 1)
             ExpressionList (children 2)
              Identifier v_date
              Literal \'2022-05-08\'
            Function lessOrEquals (children 1)
             ExpressionList (children 2)
              Identifier v_date
              Literal \'2022-06-07\'
   ExpressionList (children 1)
    Identifier vDate
   ExpressionList (children 1)
    OrderByElement (children 1)
     Identifier vDate
   Set
