3. SELECT cim, kiadasiev FROM `film` WHERE kiadasiev>=2000 ORDER BY cim ASC

4.SELECT cim, kocka, kiadasiev FROM `film` WHERE cim LIKE "%farkas%"

5.SELECT film.cim, film.kiadoid, kiado.nev, kiado.id FROM film, kiado WHERE film.cim LIKE "%sicc%" AND film.kiadoid = kiado.id

6.SELECT COUNT(cim), cim FROM `film` GROUP BY cim ORDER BY COUNT(cim) DESC

7.SELECT COUNT(film.kiadasiev),kiadasiev, cim FROM `film` GROUP BY kiadasiev ORDER BY kiadasiev DESC