-- 1.priklad
select login, rok_narozeni
from uzivatel
where rok_narozeni between 1980 and 1990 or
      rok_narozeni % 2 = 0

-- 2.priklad
select distinct k.rok
from vyrobek v
join koupil k on v.vid = k.vid
where v.jmeno like 'lampa'

-- 3.priklad
select distinct v.jmeno
from vyrobek v
join koupil k on v.vid = k.vid
join uzivatel u on k.login = u.login
where u.mesto like '%a'
order by v.jmeno desc

-- 4.priklad
select v.jmeno
from vyrobek v
join koupil k on v.vid = k.vid
where k.login like 'vinetu'
intersect
select v.jmeno
from vyrobek v
join koupil k on v.vid = k.vid
where k.login like 'pepik'

-- 5.priklad
select v.jmeno
from vyrobek v
join koupil k on v.vid = k.vid
join uzivatel u on k.login = u.login
where u.login like 'vinetu' and v.jmeno not in
(select v.jmeno
from vyrobek v
join koupil k on v.vid = k.vid
join uzivatel u on k.login = u.login
where u.login like 'pepik')

-- 6.priklad
select v.jmeno
from vyrobek v
where v.vID not in
  (select x.vid
   from vyrobek x
   join koupil k on x.vID = k.vID)

-- 7.priklad
select distinct v.jmeno
from koupil k
join vyrobek v on k.vID = v.vid
group by k.login, v.jmeno
having COUNT(*) > 1

-- 8.priklad
select distinct v.jmeno
from vyrobek v
join koupil k on v.vID = k.vid
where k.vid not in
  (select k.vid
   from koupil k
   left join vyrobek v on k.vID = v.vID
   where k.cena >= v.aktualni_cena)

-- 9.priklad - spatne
select distinct k.login
from koupil k
where cena in
(select MIN(cena)
from koupil k
group by k.vid)