begin;

drop table if exists movies;

create table movies (
   title varchar(32) primary key,
   year integer check (year > 1900),
   fresh integer check (fresh >= 0 and fresh <= 100),
   score integer check (score >= 0)
);

insert into movies values ('42', 2013, 79, 85);
insert into movies values ('Shrek', 2001, 88, 90);
insert into movies values ('Pulp Fiction', 1994, 94, 96);
insert into movies values ('Office Space', 1999, 79, 93);
insert into movies values ('Jurassic Park', 1993, 93, 91);
insert into movies values ('The Big Short', 2015, 88, 88);
insert into movies values ('Fargo', 1996, 94, 93);
insert into movies values ('A Fistful of Dollars', 1964, 98, 91);
insert into movies values ('Ocean''s 11', 2001, 82, 80);
insert into movies values ('The Silence of the Lambs', 1991, 95, 95);

commit;
