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.

 


    Customer Area

    Make your order right away

    Confidentiality and privacy guaranteed

    satisfaction guaranteed