-- Finne alle filmer utgitt p? norsk

SELECT f.title
FROM film AS f
JOIN filmlanguage AS fl
ON (f.filmid = fl.filmid)
WHERE fl.language = 'Norwegian'
;

SELECT count(f.filmid)
FROM film AS f
JOIN filmlanguage AS fl
ON (f.filmid = fl.filmid)
WHERE f.title NOT IN (
    SELECT f.title
    FROM film AS f
    JOIN filmlanguage AS fl
    ON (f.filmid = fl.filmid)
    WHERE fl.language = 'Norwegian'
) ;