-- 1
CREATE DATABASE diafilmek
CHARACTER SET utf8
COLLATE utf8_hungarian_ci;

-- 3
SELECT film.cim, film.kiadasiev
FROM film
WHERE film.kiadasiev>2000
ORDER BY film.cim ASC;

-- 4
SELECT film.cim, film.kocka, film.kiadasiev
FROM film
WHERE film.cim LIKE '%farkas%';

-- 5
SELECT DISTINCT kiado.nev
FROM kiado INNER JOIN film ON kiado.id=film.kiadoid
WHERE film.cim LIKE '%Sicc%';

-- 6
SELECT film.cim, COUNT(film.id) AS kiadasok_szama
FROM film
GROUP BY film.cim
ORDER BY kiadasok_szama DESC
LIMIT 0,1;

-- 7
SELECT film.kiadasiev, COUNT(film.id) AS darab
FROM film
WHERE film.kiadasiev>0
GROUP BY film.kiadasiev
ORDER BY darab DESC;

-- 8_seged
SELECT film.cim
FROM film
WHERE film.szinese="false";

-- 8
SELECT DISTINCT film.cim
FROM film
WHERE film.szinese="true" AND
film.cim IN (SELECT film.cim FROM film WHERE film.szinese="false");