Write a SELECT statement to select the year and the total number of movies for that year.

Movie table

Select number of movies grouped by year
-The Movie table has the following columns:
-ID – integer, primary key
-Title – variable-length string
-Genre – variable-length string
-Rating Code – variable-length string
-Year – integer

Write a SELECT statement to select the year and the total number of movies for that year.