Is there a way to get a count about grouped rows?
You GROUP BY release_year but you count release years so you will get 1s, nothing else. If you want to count them, you can enclose in a derived table and do another aggregation:

SELECT
    COUNT(*) AS release_years_with_200_titles
FROM
  (
    SELECT 1
    FROM films
    GROUP BY release_year
    HAVING COUNT(title) &gt; 200
  ) AS dt ;


It can be done without a derived table but it's not very clear how it works:

SELECT  
  COUNT(*) OVER () AS release_years_with_200_titles
FROM films
GROUP BY release_year
HAVING COUNT(title) &gt; 200
LIMIT 1 ;


The COUNT(*) OVER () will count the number of rows (after the GROUP BY and HAVING). We then can use SELECT DISTINCT or even better LIMIT 1 to get a single 13 in the result and not thirteen rows with 13.