Write a SELECT statement to select the year and the total number of movies for that year.
Computer Science 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.