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 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.

The answers provided produced no output. I am not sure what is wrong with this code?

ALTER TABLE Movie ADD Producer VARCHAR$(50)$;

ALTER TABLE MOVIE DROP COLUMN Genre;

ALTER TABLE Movie

CHANGE COLUMN Year ReleaseYear SMALLINT;

Can you please help