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

     1  // Code generated by TestPretty. DO NOT EDIT.
     2  // GENERATED FILE DO NOT EDIT
     3  1:
     4  -
     5  CREATE VIEW startrek.quotes_per_season (
     6  	season,
     7  	quotes
     8  ) AS
     9  	SELECT
    10  		startrek.episodes.season,
    11  		count(
    12  			*
    13  		)
    14  	FROM
    15  		startrek.quotes
    16  		JOIN startrek.episodes ON
    17  				startrek.quotes.episode
    18  				= startrek.episodes.id
    19  	GROUP BY
    20  		startrek.episodes.season
    21  
    22  16:
    23  ----------------
    24  CREATE VIEW startrek.quotes_per_season (
    25  	season,
    26  	quotes
    27  ) AS
    28  	SELECT
    29  		startrek.episodes.season,
    30  		count(*)
    31  	FROM
    32  		startrek.quotes
    33  		JOIN startrek.episodes ON
    34  				startrek.quotes.episode
    35  				= startrek.episodes.id
    36  	GROUP BY
    37  		startrek.episodes.season
    38  
    39  42:
    40  ------------------------------------------
    41  CREATE VIEW startrek.quotes_per_season (
    42  	season,
    43  	quotes
    44  ) AS
    45  	SELECT
    46  		startrek.episodes.season, count(*)
    47  	FROM
    48  		startrek.quotes
    49  		JOIN startrek.episodes ON
    50  				startrek.quotes.episode
    51  				= startrek.episodes.id
    52  	GROUP BY
    53  		startrek.episodes.season
    54  
    55  58:
    56  ----------------------------------------------------------
    57  CREATE VIEW startrek.quotes_per_season (season, quotes) AS
    58  	SELECT
    59  		startrek.episodes.season, count(*)
    60  	FROM
    61  		startrek.quotes
    62  		JOIN startrek.episodes ON
    63  				startrek.quotes.episode
    64  				= startrek.episodes.id
    65  	GROUP BY
    66  		startrek.episodes.season
    67  
    68  62:
    69  --------------------------------------------------------------
    70  CREATE VIEW startrek.quotes_per_season (season, quotes) AS
    71  	SELECT
    72  		startrek.episodes.season, count(*)
    73  	FROM
    74  		startrek.quotes
    75  		JOIN startrek.episodes ON
    76  				startrek.quotes.episode = startrek.episodes.id
    77  	GROUP BY
    78  		startrek.episodes.season
    79  
    80  80:
    81  --------------------------------------------------------------------------------
    82  CREATE VIEW startrek.quotes_per_season (season, quotes) AS
    83  	SELECT
    84  		startrek.episodes.season, count(*)
    85  	FROM
    86  		startrek.quotes
    87  		JOIN startrek.episodes ON startrek.quotes.episode = startrek.episodes.id
    88  	GROUP BY
    89  		startrek.episodes.season
    90  
    91  96:
    92  ------------------------------------------------------------------------------------------------
    93  CREATE VIEW startrek.quotes_per_season (season, quotes) AS
    94  	SELECT
    95  		startrek.episodes.season, count(*)
    96  	FROM
    97  		startrek.quotes JOIN startrek.episodes ON startrek.quotes.episode = startrek.episodes.id
    98  	GROUP BY
    99  		startrek.episodes.season
   100  
   101  173:
   102  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
   103  CREATE VIEW startrek.quotes_per_season (season, quotes) AS
   104  	SELECT startrek.episodes.season, count(*) FROM startrek.quotes JOIN startrek.episodes ON startrek.quotes.episode = startrek.episodes.id GROUP BY startrek.episodes.season
   105  
   106  228:
   107  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
   108  CREATE VIEW startrek.quotes_per_season (season, quotes) AS SELECT startrek.episodes.season, count(*) FROM startrek.quotes JOIN startrek.episodes ON startrek.quotes.episode = startrek.episodes.id GROUP BY startrek.episodes.season
   109  
   110