select cim "'a'-t tart a st neve" from film f where studioazon in (select azonosito from studiok where nev like '%a%');
select cim "'x'-t tart a st neve" from film f where studioazon in (select azonosito from studiok where nev like '%x%');
select szinesznev as "matrix noi szereploi" from szerepelbenne where szinesznev in
 (select nev from filmszinesz where nem='n') and filmcim='The Matrix';
select szinesznev as "matrix noi szereploi" from szerepelbenne where szinesznev in
 (select nev from filmszinesz where nem='f') and filmcim='The Matrix';
select cim "S.L.J.", hossz from film f where f.ev|cim in (select sz.ev|filmcim from szerepelbenne sz) where szinesznev="Samuel L. Jackson");
select nev "SLJ rendezoi" from gyartasiranyito where azonosito in (select producerazon from film f where f.ev|cim in(select sz.ev|filmcim from szerepelbenne sz where szinesznev="Samuel L Jackson"));
select cim from film kulso where ev>any (select ev from film where cim= kulso.cim);
select cim from film kulso where ev>any (select ev from film where cim= kulso.cim);
select distinct(f1.cim) from film f1,film f2 where f1.cim=f2.cim and not f1.ev=f2.ev;
select cim, hossz from film where hossz>all (select hossz from film where cim in ('Taxi', 'The Matrix', 'Macska-jaj'));
select cim, hossz from film where hossz>any (select hossz from film where cim in ('Taxi', 'The Matrix', 'Macska-jaj'));
select cim, hossz from film where hossz>some (select hossz from film where cim in ('Taxi', 'The Matrix', 'Macska-jaj'));