$3\mathrm{.}10\mathrm{.}1$: LAB $-$ Select number of movies grouped by year

$0/10$

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 $--$ Initialize Movie table

DROP TABLE IF EXISTS Movie;

CREATE TABLE Movie $($

ID INT unsigned NOT NULL AUTO$\_$INCREMENT,

Title VARCHAR$(30),$

Genre VARCHAR$(20),$

RatingCode VARCHAR$(5),$

Year INT,

PRIMARY KEY $($ID$)$

$)$;

INSERT INTO Movie

VALUES

$(1,$'Becoming','Documentary',$\text{'}$PG$\text{'},2020),$

$(2,$'Den of Theives','Action',$\text{'}$R$\text{'},2019),$

$(3,$'Arctic Dogs','Family',$\text{'}$PG$\text{'},2019),$

$(4,$'Dangerous Lies','Action',NULL,$2020),$

$(5,$'All Day and a Night','Drama',$\text{'}$R$\text{'},2020),$

$(6,$'Extraction','Action',$\text{'}$R$\text{'},2020),$

$(7,$'Madagascar: Escape $2$ Africa','Family',$\text{'}$PG$\text{'},2008),$

$(8,$'The Willoughbys','Family',$\text{'}$PG$\text{'},2020),$

$(9,$'Despicable Me$\text{'},$'Family',$\text{'}$PG$\text{'},2010),$

$(10,$'Armed Response','Action',$\text{'}$R$\text{'},2017)$;

COUNT$()$ function and GROUP BY clause.

$--$ Initialize database

source Initialize.sql

$--$ Your SELECT statement goes here