Rating Code

Select number of movies grouped by year then write a select statement to select the year and the total number of movies for that year.

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

Scroll to top