cnct_bioeco_eurostat_employment_totals

SELECT 
  NUTS_CODE,
  country,
  year,
  unit,
  SUM(employment) AS value
FROM [FISE].[latest].[v_bioeco_eurostat_employment] 
WHERE year=2020 and nace_r2 in ('A02', 'C16', 'C17', 'C31')
GROUP BY NUTS_CODE,country,year,unit