cnct_countryfact_eurostat_bioeco_turnover_totals

Select 
  NUTS_CODE,
  country,
  year,
  units,
  SUM(value) AS value 
from [FISE].[latest].[v_countryfact_Eurostat_bioeco_turnover]
WHERE year=2020 and nace_r2 in ('A02','C16','C17','C31')
GROUP BY NUTS_CODE,country,year,units