movie database

Hi there

I have been developing my movie database for several years as a way to keep track of what movies I see and what i thought of them.

My question is embarrassingly simple for an expert but despite trying to Google an answer I am stuck. Thanks in advance for any help

Here's my structure on the first sheet

Column A - Title
Column B - Length in minutes
Column C - Year of release
Column G - Rating out of 10 - 0 = Unseen

On a separate sheet I want to create a table that for each year showing the amount of films, released and the amount I have not seen

Released is easy as I used Countif and then the year

Unseen has me stuck because I need to countif the film was released in a specific year and the score in column G=0

Sorry to be so stupid.
Rob