create table movies (
    movieid integer Primary key,
    movie varchar(40),
    datum integer,
    country char(1),
    regie varchar(40),
    genre varchar(40)
    );
    insert into movies values(1, "Resident Evil", "2000", "u", "hulul", "horror");
    insert into movies values(2, "Hoawatslos", "2010", "a", "Hoawath", "Comedy" );
    Insert into movies values (3, "Fitzcaraldo", "1970", "a", "Werner Herzog", "Drama");


        select * from movies 

create table actors (
    actorid integer primary key, 
    name varchar(40),
    birthyear integer, 
    country char(1)
    movie references ("movieid")
    );