Question: how come these two codes doesnt have a outcome Create a Movie table with the following columns: - ID - positive integer with maximum value

Create a Movie table with the following columns: - ID - positive integer with maximum value of 50,000 - Title - variable-length string with up to 50 characters - Rating - fixed-length string with 4 characters - ReleaseDate - date - Budget - decimal value representing a cost of up to 999,999 dollars, with 2 digits for cents Note: Your SQL code does not display any results in Develop mode. Use Submit mode to test your code. Main.sql CREATE TABLE Movie C ID INTEGER NOT NULL PRIMARY KEY, Title VARCHAR(50) NOT NULL, Rating CHAR (4) NOT NULL, ReleaseDate DATE NOT NULL, Budget DECIMAL (7,2) NOT NULL )i Write ALTER statements to make the following modifications to the Movie table: 1. Add a Producer column with VARCHAR data type ( max50 chars). 2. Remove the Genre column: 3. 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 your code
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
