Question

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.

Answer 1

The query should be:

SELECT Year, COUNT(*) FROM Movie GROUP BY Year;

Explanation:

SELECT clause is used to mention the columns to be displayed on the screen.

That means, Year and the COUNT of that year should be printed on the screen.

FROM clause is used to mention the table name from which we are retrieving the data.

So, table name is Movie.

GROUP BY clause is used to tell that we have to group the rows according to the Year column, so that COUNT can be applied on it.

PLEASE UPVOTE IF YOU FOUND THIS HELPFUL!