drop view if exists produkti_cena;

create view produkti_cena as 

select p.ime, p.kolicina, m.lokacija, c.iznos
from proizvodi as p
left join parce as pr on pr.id_proizvod=p.id_proizvod
left join parce_dostapno_vo_magacini as pdm on pr.id_parce=pdm.id_parce
left join magacini as m on pdm.id_magacin=pdm.id_magacin
left join cena as c on c.id_proizvod=p.id_proizvod

group by 1, 2, 3, 4;

select pc.ime, pc.kolicina, pc.lokacija, pc.iznos as najniska_cena
from produkti_cena as pc
where pc.iznos = (select min(iznos) from produkti_cena)