select ;
        b.class,b.kat, year(a.datroj) as datroj, count(*) as koldataroj ;
from ;
        table1 as a inner join table2 as b on a.id = b.id(первая таблица)
group by  1 , 2 , 3  

select ;
        b.class,b.kat, year(a.datroj) as datroj, count(*) as koldataroj ;
from ;
        table1 a, table2 b;
where a.id = b.id(первая таблица)
group by  1 , 2 , 3