github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/sem/tree/testdata/pretty/create_view.align-deindent.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 38: 40 -------------------------------------- 41 CREATE VIEW startrek.quotes_per_season ( 42 season, 43 quotes 44 ) AS 45 SELECT startrek.episodes.season, 46 count(*) 47 FROM startrek.quotes 48 JOIN startrek.episodes ON 49 startrek.quotes.episode 50 = startrek.episodes.id 51 GROUP BY startrek.episodes.season 52 53 40: 54 ---------------------------------------- 55 CREATE VIEW startrek.quotes_per_season ( 56 season, 57 quotes 58 ) AS SELECT startrek.episodes.season, 59 count(*) 60 FROM startrek.quotes 61 JOIN startrek.episodes ON 62 startrek.quotes.episode 63 = startrek.episodes.id 64 GROUP BY startrek.episodes.season 65 66 48: 67 ------------------------------------------------ 68 CREATE VIEW startrek.quotes_per_season ( 69 season, 70 quotes 71 ) AS SELECT startrek.episodes.season, count(*) 72 FROM startrek.quotes 73 JOIN startrek.episodes ON 74 startrek.quotes.episode 75 = startrek.episodes.id 76 GROUP BY startrek.episodes.season 77 78 58: 79 ---------------------------------------------------------- 80 CREATE VIEW startrek.quotes_per_season ( 81 season, 82 quotes 83 ) AS SELECT startrek.episodes.season, count(*) 84 FROM startrek.quotes 85 JOIN startrek.episodes ON startrek.quotes.episode 86 = startrek.episodes.id 87 GROUP BY startrek.episodes.season 88 89 65: 90 ----------------------------------------------------------------- 91 CREATE VIEW startrek.quotes_per_season (season, quotes) AS SELECT 92 startrek.episodes.season, 93 count( 94 * 95 ) 96 FROM 97 startrek.quotes 98 JOIN startrek.episodes ON 99 startrek.quotes.episode 100 = startrek.episodes.id 101 GROUP BY 102 startrek.episodes.season 103 104 68: 105 -------------------------------------------------------------------- 106 CREATE VIEW startrek.quotes_per_season (season, quotes) AS SELECT 107 startrek.episodes.season, 108 count(*) 109 FROM 110 startrek.quotes 111 JOIN startrek.episodes ON 112 startrek.quotes.episode 113 = startrek.episodes.id 114 GROUP BY 115 startrek.episodes.season 116 117 93: 118 --------------------------------------------------------------------------------------------- 119 CREATE VIEW startrek.quotes_per_season (season, quotes) AS SELECT startrek.episodes.season, 120 count(*) 121 FROM startrek.quotes 122 JOIN startrek.episodes ON 123 startrek.quotes.episode 124 = startrek.episodes.id 125 GROUP BY startrek.episodes.season 126 127 102: 128 ------------------------------------------------------------------------------------------------------ 129 CREATE VIEW startrek.quotes_per_season (season, quotes) AS SELECT startrek.episodes.season, count(*) 130 FROM startrek.quotes 131 JOIN startrek.episodes ON 132 startrek.quotes.episode 133 = startrek.episodes.id 134 GROUP BY startrek.episodes.season 135 136 112: 137 ---------------------------------------------------------------------------------------------------------------- 138 CREATE VIEW startrek.quotes_per_season (season, quotes) AS SELECT startrek.episodes.season, count(*) 139 FROM startrek.quotes 140 JOIN startrek.episodes ON startrek.quotes.episode 141 = startrek.episodes.id 142 GROUP BY startrek.episodes.season 143 144 135: 145 --------------------------------------------------------------------------------------------------------------------------------------- 146 CREATE VIEW startrek.quotes_per_season (season, quotes) AS SELECT startrek.episodes.season, count(*) 147 FROM startrek.quotes 148 JOIN startrek.episodes ON startrek.quotes.episode = startrek.episodes.id 149 GROUP BY startrek.episodes.season 150 151 156: 152 ------------------------------------------------------------------------------------------------------------------------------------------------------------ 153 CREATE VIEW startrek.quotes_per_season (season, quotes) AS SELECT startrek.episodes.season, count(*) 154 FROM startrek.quotes JOIN startrek.episodes ON startrek.quotes.episode = startrek.episodes.id 155 GROUP BY startrek.episodes.season 156 157 228: 158 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 159 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 160 161