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

Computer Science by Geoffrey

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.