SELECT 'Pan '||titul||' '|| jmeno|| ' pracuje v oddeleni', cis_odd FROM zam;
SELECT * FROM zam WHERE fce IN ('PROJEKTANT', 'PROGRAMATOR', 'TECHNIK');
SELECT * FROM zam WHERE plat BETWEEN 10000 AND 11000;
SELECT * FROM zam WHERE jmeno LIKE 'K%';
SELECT * FROM zam WHERE titul IS NULL;
SELECT * FROM zam WHERE titul IS NOT NULL;
SELECT * FROM zam WHERE titul IN ('ING', 'RNDR') AND plat<11000;
SELECT nazev FROM oddel WHERE cis_odd IN (SELECT cis_odd FROM zam WHERE titul IN ('ING', 'RNDR') AND plat<11000);

SELECT nazev, os_cis, jmeno FROM oddel JOIN zam ON zam.cis_odd=oddel.cis_odd WHERE titul IN ('ING', 'RNDR') AND plat<11000;

SELECT nazev, os_cis, jmeno FROM oddel JOIN zam USING (cis_odd) WHERE titul IN ('ING', 'RNDR') AND plat<11000;

SELECT nazev, os_cis, jmeno FROM oddel JOIN zam ON sef=os_cis;

SELECT cis_uk, popis, os_cis, jmeno FROM ukoly JOIN zam ON ukoly.os_cis=zam.os_cis;