cnct_biodiv_son20_4_5_1_average_deadwood

SELECT 
  'EU27' AS NUTS_CODE,
  'EU27' AS country,
  AVG(forest) AS volume,
  year,
  variable AS regime 
FROM FISE.latest.v_biodiv_soef20_deadwood
WHERE order_in_chart=0 AND NUTS_CODE IN (SELECT NUTS_CODE FROM FISE.latest.countries WHERE EU27=1)
GROUP BY variable,year 
No data