--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'
)