Број на одобрени набавки (продажби) по производи и година

CREATE MATERIALIZED VIEW brojac_na_nabavki_godisno AS SELECT

EXTRACT(YEAR FROM p.ProcurementDate) AS godina, pr.Model AS proizvod, COUNT(*) AS broj_nabavki

FROM procurement p JOIN product pr ON p.ProductID = pr.ProductID WHERE p.Status = 'Approved' GROUP BY godina, proizvod ORDER BY godina, proizvod DESC;

CREATE INDEX idx_brojac_na_nabavki ON brojac_na_nabavki_godisno(godina, proizvod);