Good evening,

Firstly I want to thank everyone who has ever helped me. I never have a chance to say thank you unless some how there's a zoom call...but thanks for all of your support. I'm new to IT and it means a great deal. I look forward to helping people on here one day soon. I have a question about a lab I am having trouble with. We're learning SQL, but it's my first go and there's never enough time to truly learn it before the course is over.

Question:

LAB - Create Movie table

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.

Here is the code I am using, but I am not getting as far as I would like.

CREATE TABLE Movie ( ID INT CHECK (ID>=1 AND ID <= 50000), Title VARCHAR(50), Rating CHAR(4), ReleaseDate Date, Budget DECIMAL(8,2) );

If anyone can help I greatly appreciate it truly----if not thank you and best wishes truly.

warm regards,

Lily