TAZAJEBANA NALOGA

CREATE OR REPLACE VIEW temp AS
SELECt k.naziv, COUNT(*) as stevilo
FROM oseba o
INNER JOIN naslov n ON o.fk_naslov = n.id_naslov
INNER JOIN kraj k ON k.id_kraj = n.id_kraj_tk
GROUP BY k.id_kraj;

SELECT * from temp
WHERE stevilo = (SELECT MAX(stevilo) FROM temp);