I am trying to get a count about a grouped rows. Here is a description of the table of relevance:
column_name data_type ------------- --------- id integer title character varying release_year integer country character varying duration integer language character varying certification character varying gross bigint budget bigint
I am to trying to determine how many different years exist during which more than 200 movies were released.
Here is the query I have tried so far:
SELECT count(DISTINCT release_year) FROM films GROUP BY release_year HAVING COUNT(title) > 200;
...which gives 13 rows of
The question is: how to get a number 13?