Baselight
select year(year_month) as year
       , sum(registo_de_marcas) as trademarks
       , sum(inven_es) as inventions
       , sum(design) as designs
from @ptgov.propriedadeindustrial.propriedadeindustrial
where year(year_month) < 2025
group by 1
order by 1;
yeartrademarksinventionsdesigns
2016210399392291
2017225238461607
2018228568381350
2019215569682058
20202142611241744
2021240049201110
2022202409151050
202320920903813
202421529951610

Share link

Anyone who has the link will be able to view this.