/* Finne alle filmer p? norsk */
SELECT count(f.title) 
FROM film AS f 
JOIN filmlanguage AS fl 
ON (f.filmid = fl.filmid) 
WHERE fl.language = 'Norwegian'
;
/*
Hvordan kunne vi forenklet denne litt?
N?R DU BARE SKRIVER JOIN BETYR DET "INNER"
*/

/* Finne alle filmer p? ikke-norsk */
SELECT count(f.title)
FROM film AS f
WHERE f.title NOT IN (
    SELECT f.title 
    FROM film AS f 
    NATURAL JOIN filmlanguage AS fl 
    WHERE fl.language = 'Norwegian'
);