Create cast_info

CREATE TABLE cast_info AS
    SELECT DISTINCT ci.movie_id, ci.person_id, cn.name AS char_name, rt.role, ci.note, ci.nr_order 
    FROM imdb.ex x, imdb.cast_info ci, imdb.role_type rt, imdb.char_name cn 
    WHERE x.id = ci.movie_id 
    AND ci.role_id = rt.id 
    AND ci.person_role = cn.id;