DAT/380 Week 4 LAB 4.7 – Select number of movies grouped by year

$ 5

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

996 in stock

SKU: DAT380WK4L4P7 Category:

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.

Only logged in customers who have purchased this product may leave a review.

You may also like…