CREATE VIEW 2_Tovari AS SELECT Kod_tov AS Kod_tovara, sum(R.kol_vo) as Sum_kol_tov from 3_razmeri R group by Kod_tov;