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

Availability: In stock

Regular Price: $5.00

Special Price: $3.00

OR

DAT380 Week 4 LAB 4.7 - Select number of movies grouped by year

Double click on above image to view full picture

Zoom Out
Zoom In

More Views

Quick Overview

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

Regular Price: $5.00

Special Price: $3.00

Details

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

Additional Information

Special Price $3.00

Product Tags

Use spaces to separate tags. Use single quotes (') for phrases.