SELECT
release_year,
COUNT(CASE WHEN type = 'TV Show' THEN show_id END) AS number_of_series,
COUNT(CASE WHEN type = 'Movie' THEN show_id END) AS number_of_movies
FROM
@kaggle.arnavvvvv_netflix_movies_and_tv_shows.netflix_titles
GROUP BY
release_year
ORDER BY
release_year ASC