$2\mathrm{.}14$ LAB $-$ Alter Movie table

The Movie table has the following columns:

ID $-$ positive integer

Title$-$variable$-$length string

Genre$-$variable$-$length string

RatingCode $-$ variable$-$length string

Year$-$integer

Write ALTER statements to make the following modifications to the Movie table:

Add a Producer column with VARCHAR data type $($max $50$ chars$).$

Remove the Genre column.

Change the Year column's name to ReleaseYear, and change the data type to SMALLINT.

Note: Your SQL code does not display any results in Develop mode. Use Submit mode to test yo

$\left[\begin{array}{cc}\text{L}\text{A}\text{B}& ?\\ \text{A}\text{C}\text{T}\text{I}\text{V}\text{I}\text{T}\text{Y}& 2\mathrm{.}14\mathrm{.}1\text{:}\text{L}\text{A}\text{B}-\text{A}\text{l}\text{t}\text{e}\text{r}\text{M}\text{o}\text{v}\text{i}\text{e}\text{t}\text{a}\text{b}\text{l}\text{e}\end{array}\right]$