TheMovietable 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:

1. Add aProducercolumn with VARCHAR data type (max 50 chars).


2. Remove theGenrecolumn.


3. Change the Year column's name toReleaseYear, and change the data type toSMALLINT.