1select year(year_month) as year
2       , sum(registo_de_marcas) as trademarks
3       , sum(inven_es) as inventions
4       , sum(design) as designs
5from @ptgov.propriedadeindustrial.propriedadeindustrial
6where year(year_month) < 2025
7group by 1
8order by 1;