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.