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

Computer Science
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
RatingCode – variable-length string
Year – integer
Write a SELECT statement to select the year and the total number of movies for that year.