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

     1  CREATE VIEW startrek.quotes_per_season (season, quotes)
     2  AS SELECT startrek.episodes.season, count(*)
     3  FROM startrek.quotes
     4  JOIN startrek.episodes
     5  ON startrek.quotes.episode = startrek.episodes.id
     6  GROUP BY startrek.episodes.season