github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/sem/tree/testdata/pretty/2.align-deindent.golden (about)

     1  // Code generated by TestPretty. DO NOT EDIT.
     2  // GENERATED FILE DO NOT EDIT
     3  1:
     4  -
     5  SELECT
     6  	count(
     7  		*
     8  	)
     9  		AS count,
    10  	winner,
    11  	counter
    12  	* 60
    13  	* 5
    14  		AS counter
    15  FROM
    16  	(
    17  		SELECT
    18  			winner,
    19  			round(
    20  				length
    21  				/ 60
    22  				/ 5
    23  			)
    24  				AS counter
    25  		FROM
    26  			players
    27  		WHERE
    28  			build
    29  			= $1
    30  			AND (
    31  					hero
    32  					= $2
    33  					OR region
    34  						= $3
    35  				)
    36  	)
    37  GROUP BY
    38  	winner,
    39  	counter
    40  
    41  10:
    42  ----------
    43  SELECT
    44  	count(
    45  		*
    46  	) AS count,
    47  	winner,
    48  	counter
    49  	* 60
    50  	* 5
    51  		AS counter
    52  FROM
    53  	(
    54  		SELECT
    55  			winner,
    56  			round(
    57  				length
    58  				/ 60
    59  				/ 5
    60  			)
    61  				AS counter
    62  		FROM
    63  			players
    64  		WHERE
    65  			build
    66  			= $1
    67  			AND (
    68  					hero
    69  					= $2
    70  					OR region
    71  						= $3
    72  				)
    73  	)
    74  GROUP BY
    75  	winner,
    76  	counter
    77  
    78  11:
    79  -----------
    80  SELECT
    81  	count(
    82  		*
    83  	) AS count,
    84  	winner,
    85  	counter
    86  	* 60
    87  	* 5 AS counter
    88  FROM
    89  	(
    90  		SELECT
    91  			winner,
    92  			round(
    93  				length
    94  				/ 60
    95  				/ 5
    96  			)
    97  				AS counter
    98  		FROM
    99  			players
   100  		WHERE
   101  			build
   102  			= $1
   103  			AND (
   104  					hero
   105  					= $2
   106  					OR region
   107  						= $3
   108  				)
   109  	)
   110  GROUP BY
   111  	winner,
   112  	counter
   113  
   114  15:
   115  ---------------
   116    SELECT count(
   117  			*
   118           ) AS count,
   119           winner,
   120           counter
   121           * 60
   122           * 5
   123  			AS counter
   124      FROM (
   125  			SELECT
   126  				winner,
   127  				round(
   128  					length
   129  					/ 60
   130  					/ 5
   131  				)
   132  					AS counter
   133  			FROM
   134  				players
   135  			WHERE
   136  				build
   137  				= $1
   138  				AND (
   139  						hero
   140  						= $2
   141  						OR region
   142  							= $3
   143  					)
   144           )
   145  GROUP BY winner,
   146           counter
   147  
   148  16:
   149  ----------------
   150    SELECT count(
   151  			*
   152           ) AS count,
   153           winner,
   154           counter
   155           * 60
   156           * 5 AS counter
   157      FROM (
   158  			SELECT
   159  				winner,
   160  				round(
   161  					length
   162  					/ 60
   163  					/ 5
   164  				)
   165  					AS counter
   166  			FROM
   167  				players
   168  			WHERE
   169  				build
   170  				= $1
   171  				AND (
   172  						hero
   173  						= $2
   174  						OR region
   175  							= $3
   176  					)
   177           )
   178  GROUP BY winner,
   179           counter
   180  
   181  22:
   182  ----------------------
   183    SELECT count(
   184  			*
   185           ) AS count,
   186           winner,
   187           counter
   188           * 60
   189           * 5 AS counter
   190      FROM (
   191  			SELECT
   192  				winner,
   193  				round(
   194  					length
   195  					/ 60
   196  					/ 5
   197  				) AS counter
   198  			FROM
   199  				players
   200  			WHERE
   201  				build
   202  				= $1
   203  				AND (
   204  						hero
   205  						= $2
   206  						OR region
   207  							= $3
   208  					)
   209           )
   210  GROUP BY winner,
   211           counter
   212  
   213  24:
   214  ------------------------
   215    SELECT count(
   216  			*
   217           ) AS count,
   218           winner,
   219           counter
   220           * 60
   221           * 5 AS counter
   222      FROM (
   223  			SELECT
   224  				winner,
   225  				round(
   226  					length
   227  					/ 60
   228  					/ 5
   229  				) AS counter
   230  			FROM
   231  				players
   232  			WHERE
   233  				build
   234  				= $1
   235  				AND (
   236  						hero
   237  						= $2
   238  						OR region
   239  							= $3
   240  					)
   241           )
   242  GROUP BY winner, counter
   243  
   244  26:
   245  --------------------------
   246    SELECT count(
   247  			*
   248           ) AS count,
   249           winner,
   250           counter
   251           * 60
   252           * 5 AS counter
   253      FROM (
   254  			SELECT winner,
   255  			       round(
   256  					length
   257  					/ 60
   258  					/ 5
   259  			       ) AS counter
   260  			  FROM players
   261  			 WHERE build
   262  			       = $1
   263  			   AND (
   264  					hero
   265  					= $2
   266  					OR region
   267  						= $3
   268  			       )
   269           )
   270  GROUP BY winner, counter
   271  
   272  27:
   273  ---------------------------
   274    SELECT count(*) AS count,
   275           winner,
   276           counter
   277           * 60
   278           * 5 AS counter
   279      FROM (
   280  			SELECT winner,
   281  			       round(
   282  					length
   283  					/ 60
   284  					/ 5
   285  			       ) AS counter
   286  			  FROM players
   287  			 WHERE build
   288  			       = $1
   289  			   AND (
   290  					hero
   291  					= $2
   292  					OR region
   293  						= $3
   294  			       )
   295           )
   296  GROUP BY winner, counter
   297  
   298  29:
   299  -----------------------------
   300    SELECT count(*) AS count,
   301           winner,
   302           counter
   303           * 60
   304           * 5 AS counter
   305      FROM (
   306  			SELECT winner,
   307  			       round(
   308  					length
   309  					/ 60
   310  					/ 5
   311  			       ) AS counter
   312  			  FROM players
   313  			 WHERE build = $1
   314  			   AND (
   315  					hero = $2
   316  					OR region
   317  						= $3
   318  			       )
   319           )
   320  GROUP BY winner, counter
   321  
   322  34:
   323  ----------------------------------
   324    SELECT count(*) AS count,
   325           winner,
   326           counter
   327           * 60
   328           * 5 AS counter
   329      FROM (
   330  			SELECT winner,
   331  			       round(
   332  					length
   333  					/ 60
   334  					/ 5
   335  			       ) AS counter
   336  			  FROM players
   337  			 WHERE build = $1
   338  			   AND (
   339  					hero = $2
   340  					OR region = $3
   341  			       )
   342           )
   343  GROUP BY winner, counter
   344  
   345  35:
   346  -----------------------------------
   347    SELECT count(*) AS count,
   348           winner,
   349           counter
   350           * 60
   351           * 5 AS counter
   352      FROM (
   353  			SELECT winner,
   354  			       round(
   355  					length / 60 / 5
   356  			       ) AS counter
   357  			  FROM players
   358  			 WHERE build = $1
   359  			   AND (
   360  					hero = $2
   361  					OR region = $3
   362  			       )
   363           )
   364  GROUP BY winner, counter
   365  
   366  36:
   367  ------------------------------------
   368    SELECT count(*) AS count,
   369           winner,
   370           counter * 60 * 5 AS counter
   371      FROM (
   372  			SELECT winner,
   373  			       round(
   374  					length / 60 / 5
   375  			       ) AS counter
   376  			  FROM players
   377  			 WHERE build = $1
   378  			   AND (
   379  					hero = $2
   380  					OR region = $3
   381  			       )
   382           )
   383  GROUP BY winner, counter
   384  
   385  45:
   386  ---------------------------------------------
   387    SELECT count(*) AS count,
   388           winner,
   389           counter * 60 * 5 AS counter
   390      FROM (
   391  			SELECT winner,
   392  			       round(
   393  					length / 60 / 5
   394  			       ) AS counter
   395  			  FROM players
   396  			 WHERE build = $1
   397  			   AND (hero = $2 OR region = $3)
   398           )
   399  GROUP BY winner, counter
   400  
   401  52:
   402  ----------------------------------------------------
   403    SELECT count(*) AS count,
   404           winner,
   405           counter * 60 * 5 AS counter
   406      FROM (
   407  			SELECT winner,
   408  			       round(length / 60 / 5) AS counter
   409  			  FROM players
   410  			 WHERE build = $1
   411  			   AND (hero = $2 OR region = $3)
   412           )
   413  GROUP BY winner, counter
   414  
   415  60:
   416  ------------------------------------------------------------
   417    SELECT count(*) AS count,
   418           winner,
   419           counter * 60 * 5 AS counter
   420      FROM (
   421  			SELECT winner, round(length / 60 / 5) AS counter
   422  			  FROM players
   423  			 WHERE build = $1 AND (hero = $2 OR region = $3)
   424           )
   425  GROUP BY winner, counter
   426  
   427  63:
   428  ---------------------------------------------------------------
   429    SELECT count(*) AS count, winner, counter * 60 * 5 AS counter
   430      FROM (
   431  			SELECT winner, round(length / 60 / 5) AS counter
   432  			  FROM players
   433  			 WHERE build = $1 AND (hero = $2 OR region = $3)
   434           )
   435  GROUP BY winner, counter
   436  
   437  120:
   438  ------------------------------------------------------------------------------------------------------------------------
   439    SELECT count(*) AS count, winner, counter * 60 * 5 AS counter
   440      FROM (SELECT winner, round(length / 60 / 5) AS counter FROM players WHERE build = $1 AND (hero = $2 OR region = $3))
   441  GROUP BY winner, counter
   442  
   443  203:
   444  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
   445  SELECT count(*) AS count, winner, counter * 60 * 5 AS counter FROM (SELECT winner, round(length / 60 / 5) AS counter FROM players WHERE build = $1 AND (hero = $2 OR region = $3)) GROUP BY winner, counter
   446  
   447