select
kat_nev
,
count
(
*
)
from
aru
natural
join
kategoria
group
by
kat_kod
,
kat_nev
;