Description
DAT/380 Week 4 LAB 4.7 – 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.
Hint: Use the COUNT() function and GROUP BY clause
Reviews
There are no reviews yet.