cnct_etc_cme_ghg_4a1_4a2_co2

cnct_etc_cme_ghg_4a1_4a2_co2

SELECT 
      [Code]
      ,[Year]
      ,[Unit]
      ,[Submission_date]
      ,[Biomass Net]
      ,[Dead wood]
      ,[Litter]
      ,[Min Soil]
      ,[Org Soil]
      ,[Total]
FROM [FISE].[v1r1].[v_ETC_CME_GHG]
WHERE Submission_date='May-2021' AND (Code='4A.1' OR Code='4A.2' OR Code='Total_4A1_4A2')
ORDER BY Code, Year