--1 ZADACI ZA OCENU LAB
/*
SELECT F.IdFir, F.Naziv, F.Adresa
FROM Firma F, Posiljka P
WHERE P.IdFir = F.IdFir AND F.Naziv LIKE 'p%'
GROUP BY F.IdFir, F.Naziv,F.Adresa
HAVING COUNT(*)>=2
*/
--2
/*
SELECT K.IdKam, K.Marka
FROM Kamion K, Putovanje put, Posiljka pos, sePrevozi sp
WHERE put.IdKam = K.IdKam AND sp.IdPut = Put.IdPut AND sp.IdPos = Pos.IdPos
GROUP BY K.IdKam, K.Marka
*/

--3
/*
SELECT *
FROM Mehanicar M, Zaposlen Z
WHERE Z.IdZap  = M.IdZap AND M.IdZap NOT IN(Select IdZap
                                            FROM Popravlja)
                                /*NOT EXISTS(Select*
                                        FROM Popravlja pop
                                        WHERE pop.IdZap = M.IdZap)*/
*/

--4