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 activity IN (SELECT distinct(sector) FROM [FISE].[latest].[v_bioeco_eurostat_employment])
GROUP BY NUTS_CODE,country,year,units
No data