github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/sem/tree/testdata/pretty/2.ref.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  12:
    42  ------------
    43  SELECT
    44  	count(*)
    45  		AS count,
    46  	winner,
    47  	counter
    48  	* 60
    49  	* 5
    50  		AS counter
    51  FROM
    52  	(
    53  		SELECT
    54  			winner,
    55  			round(
    56  				length
    57  				/ 60
    58  				/ 5
    59  			)
    60  				AS counter
    61  		FROM
    62  			players
    63  		WHERE
    64  			build
    65  			= $1
    66  			AND (
    67  					hero
    68  					= $2
    69  					OR region
    70  						= $3
    71  				)
    72  	)
    73  GROUP BY
    74  	winner,
    75  	counter
    76  
    77  19:
    78  -------------------
    79  SELECT
    80  	count(*)
    81  		AS count,
    82  	winner,
    83  	counter
    84  	* 60
    85  	* 5
    86  		AS counter
    87  FROM
    88  	(
    89  		SELECT
    90  			winner,
    91  			round(
    92  				length
    93  				/ 60
    94  				/ 5
    95  			)
    96  				AS counter
    97  		FROM
    98  			players
    99  		WHERE
   100  			build
   101  			= $1
   102  			AND (
   103  					hero
   104  					= $2
   105  					OR region
   106  						= $3
   107  				)
   108  	)
   109  GROUP BY
   110  	winner, counter
   111  
   112  20:
   113  --------------------
   114  SELECT
   115  	count(*)
   116  		AS count,
   117  	winner,
   118  	counter * 60 * 5
   119  		AS counter
   120  FROM
   121  	(
   122  		SELECT
   123  			winner,
   124  			round(
   125  				length
   126  				/ 60
   127  				/ 5
   128  			)
   129  				AS counter
   130  		FROM
   131  			players
   132  		WHERE
   133  			build
   134  			= $1
   135  			AND (
   136  					hero
   137  					= $2
   138  					OR region
   139  						= $3
   140  				)
   141  	)
   142  GROUP BY
   143  	winner, counter
   144  
   145  22:
   146  ----------------------
   147  SELECT
   148  	count(*) AS count,
   149  	winner,
   150  	counter * 60 * 5
   151  		AS counter
   152  FROM
   153  	(
   154  		SELECT
   155  			winner,
   156  			round(
   157  				length
   158  				/ 60
   159  				/ 5
   160  			)
   161  				AS counter
   162  		FROM
   163  			players
   164  		WHERE
   165  			build = $1
   166  			AND (
   167  					hero
   168  					= $2
   169  					OR region
   170  						= $3
   171  				)
   172  	)
   173  GROUP BY
   174  	winner, counter
   175  
   176  29:
   177  -----------------------------
   178  SELECT
   179  	count(*) AS count,
   180  	winner,
   181  	counter * 60 * 5
   182  		AS counter
   183  FROM
   184  	(
   185  		SELECT
   186  			winner,
   187  			round(
   188  				length
   189  				/ 60
   190  				/ 5
   191  			)
   192  				AS counter
   193  		FROM
   194  			players
   195  		WHERE
   196  			build = $1
   197  			AND (
   198  					hero = $2
   199  					OR region
   200  						= $3
   201  				)
   202  	)
   203  GROUP BY
   204  	winner, counter
   205  
   206  31:
   207  -------------------------------
   208  SELECT
   209  	count(*) AS count,
   210  	winner,
   211  	counter * 60 * 5 AS counter
   212  FROM
   213  	(
   214  		SELECT
   215  			winner,
   216  			round(
   217  				length / 60 / 5
   218  			)
   219  				AS counter
   220  		FROM
   221  			players
   222  		WHERE
   223  			build = $1
   224  			AND (
   225  					hero = $2
   226  					OR region
   227  						= $3
   228  				)
   229  	)
   230  GROUP BY
   231  	winner, counter
   232  
   233  34:
   234  ----------------------------------
   235  SELECT
   236  	count(*) AS count,
   237  	winner,
   238  	counter * 60 * 5 AS counter
   239  FROM
   240  	(
   241  		SELECT
   242  			winner,
   243  			round(length / 60 / 5)
   244  				AS counter
   245  		FROM
   246  			players
   247  		WHERE
   248  			build = $1
   249  			AND (
   250  					hero = $2
   251  					OR region = $3
   252  				)
   253  	)
   254  GROUP BY
   255  	winner, counter
   256  
   257  42:
   258  ------------------------------------------
   259  SELECT
   260  	count(*) AS count,
   261  	winner,
   262  	counter * 60 * 5 AS counter
   263  FROM
   264  	(
   265  		SELECT
   266  			winner,
   267  			round(length / 60 / 5)
   268  				AS counter
   269  		FROM
   270  			players
   271  		WHERE
   272  			build = $1
   273  			AND (hero = $2 OR region = $3)
   274  	)
   275  GROUP BY
   276  	winner, counter
   277  
   278  45:
   279  ---------------------------------------------
   280  SELECT
   281  	count(*) AS count,
   282  	winner,
   283  	counter * 60 * 5 AS counter
   284  FROM
   285  	(
   286  		SELECT
   287  			winner,
   288  			round(length / 60 / 5) AS counter
   289  		FROM
   290  			players
   291  		WHERE
   292  			build = $1
   293  			AND (hero = $2 OR region = $3)
   294  	)
   295  GROUP BY
   296  	winner, counter
   297  
   298  53:
   299  -----------------------------------------------------
   300  SELECT
   301  	count(*) AS count,
   302  	winner,
   303  	counter * 60 * 5 AS counter
   304  FROM
   305  	(
   306  		SELECT
   307  			winner, round(length / 60 / 5) AS counter
   308  		FROM
   309  			players
   310  		WHERE
   311  			build = $1 AND (hero = $2 OR region = $3)
   312  	)
   313  GROUP BY
   314  	winner, counter
   315  
   316  58:
   317  ----------------------------------------------------------
   318  SELECT
   319  	count(*) AS count, winner, counter * 60 * 5 AS counter
   320  FROM
   321  	(
   322  		SELECT
   323  			winner, round(length / 60 / 5) AS counter
   324  		FROM
   325  			players
   326  		WHERE
   327  			build = $1 AND (hero = $2 OR region = $3)
   328  	)
   329  GROUP BY
   330  	winner, counter
   331  
   332  115:
   333  -------------------------------------------------------------------------------------------------------------------
   334  SELECT
   335  	count(*) AS count, winner, counter * 60 * 5 AS counter
   336  FROM
   337  	(SELECT winner, round(length / 60 / 5) AS counter FROM players WHERE build = $1 AND (hero = $2 OR region = $3))
   338  GROUP BY
   339  	winner, counter
   340  
   341  203:
   342  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
   343  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
   344  
   345