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...

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.

Hint: Use the COUNT() function and GROUP BY clause.

NOTE: Starter code has been provided. Simply change the blanks ("_") to the appropriate entity/value.