--1. select * from Uzivatel where (rok_narozeni between 1980 and 1990) or (rok_narozeni % 2 = 0) --2 select distinct rok from koupil k, vyrobek v where k.vID = v.vID and v.jmeno='lampa' --3 select distinct u.login, v.jmeno from uzivatel u, koupil k,vyrobek v where u.login=k.login and v.vID=k.vID and u.mesto='Ostrava' --4 select distinct v.jmeno from vyrobek v, koupil k, uzivatel u where v.vID=k.vID and u.login = k.login and u.mesto like '%a' order by v.jmeno desc --5 select v.jmeno from vyrobek v, koupil k, uzivatel u where v.vID=k.vID and u.login = k.login and u.login = 'vinetu' INTERSECT select v.jmeno from vyrobek v, koupil k, uzivatel u where v.vID=k.vID and u.login = k.login and u.login = 'pepik' --6 select v.jmeno from vyrobek v, koupil k, uzivatel u where v.vID=k.vID and u.login = k.login and u.login = 'vinetu' EXCEPT select v.jmeno from vyrobek v, koupil k, uzivatel u where v.vID=k.vID and u.login = k.login and u.login = 'pepik' --7 select v.jmeno from vyrobek v except select v.jmeno from koupil k,vyrobek v where v.vID=k.vID --8 ( select v.jmeno from vyrobek v, koupil k, uzivatel u where v.vID=k.vID and u.login = k.login and u.login = 'vinetu' union select v.jmeno from vyrobek v, koupil k, uzivatel u where v.vID=k.vID and u.login = k.login and u.login = 'pepik' ) except ( select v.jmeno from vyrobek v, koupil k, uzivatel u where v.vID=k.vID and u.login = k.login and u.login = 'vinetu' INTERSECT select v.jmeno from vyrobek v, koupil k, uzivatel u where v.vID=k.vID and u.login = k.login and u.login = 'pepik' )