cnct_countryfact_eurostat_bioeco_value_added_totals

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

No data