Baselight
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
release_yearnumber_of_seriesnumber_of_movies
192510
194202
194303
194403
194513
194611
194701
195402
195503
195602
195803
195901
196004
196101
196203
196311
196402
196502
196601
196714
196803
196902
197002
197105
197214
1973010
197416
197507
197609
197716
197807
1979110
1980011
1981112
1982017
1983011
1984012
198519
1986211
198708
1988216
1989115
1990319
1991116
1992320
1993424
1994220
1995223
1996321
1997434
1998432
1999732
2000433
2001540
2002744
20031051
2004955
20051367
20061482
20071474
200823113
200934118
201040154
201140145
201264173
201363225
201488264
2015162398
2016244658
2017265767
2018380767
2019397633
2020436517
2021315277

Share link

Anyone who has the link will be able to view this.