DROP TABLE Movie; 
/* Delete table if it already exists */

CREATE TABLE Movie (
  title varchar(25),
  year int,
  length int,
  inColor int,
  studioName varchar(15),
  producerC varchar(3)
);

INSERT INTO Movie VALUES ('Pretty Woman', 1990, 119, 1, 'Disney', '999');
INSERT INTO Movie VALUES ('The Man Who Wasn''t There', 2001, 116, 0, 'USA Entertainm.', '777');
INSERT INTO Movie VALUES ('Logan''s run', 1976, NULL, 1, '', '888');
INSERT INTO Movie VALUES ('Star Wars', 1977, 124, 1, 'Fox', '555');
INSERT INTO Movie VALUES ('Empire Strikes Back', 1980, 111, 1, 'Fox', '555');
INSERT INTO Movie VALUES ('Star Trek', 1979, 132, 1, 'Paramount', '444');
INSERT INTO Movie VALUES ('Star Trek: Nemesis', 2002, 116, 1, 'Paramount', '321');
INSERT INTO Movie VALUES ('Terms of Endearment', 1983, 132, 1, 'MGM', '123');
INSERT INTO Movie VALUES ('The Usual Suspects', 1995, 106, 1, 'MGM', '999');
INSERT INTO Movie VALUES ('Gone With the Wind', 1938, 238, 1, 'MGM', '123');