Home /
Database /
DAT380 Advanced Database Architecture /
DAT/380 Week 4 LAB 4.7 - Select number of movies grouped by year

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

Availability: In stock

$5.00

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

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

Double click on above image to view full picture

More Views

This assignment includes MYSQL queries

Download DAT/380 4.7 LAB

$5.00

Qty:

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.

My Cart

You have no items in your shopping cart.