Greenhouse gas projections with existing measures

PREFIX tableFile: <http://semantic.eea.europa.eu/project/ghg_projections/ghg_projections.tsv#>
PREFIX country: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/country/>

SELECT DISTINCT
?date
round(sum(?wem_energy_supply)/100)/10.0 as ?wem_energy_supply
round(sum(?wem_energy_use)/100)/10.0 as ?wem_energy_use
round(sum(?wem_transport)/100)/10.0 as ?wem_transport
round(sum(?wem_industrial_processes)/100)/10.0 as ?wem_industrial_processes
round(sum(?wem_waste)/100)/10.0 as ?wem_waste
round(sum(?wem_agriculture)/100)/10.0 as ?wem_agriculture
round(sum(?wem_solvents)/100)/10.0 as ?wem_solvents

FROM <http://semantic.eea.europa.eu/project/ghg_projections/ghg_projections.tsv>
WHERE {
  _:ghg_projections tableFile:country_code ?country_code .
  FILTER (?country_code != country:NO and ?country_code != country:CH and ?country_code != country:LI)
  _:ghg_projections tableFile:year ?date . 
  #FILTER (?date != 'Ref 2010' and ?date != 'Ref 2011' and ?date != 'Ref 2012')
  FILTER (?date in ('2010', '2011', '2012', '2013', '2014', '2015', '2016', '2017', '2018', '2019', '2020', '2025', '2030')) 
  _:ghg_projections tableFile:pollutant_name ?pollutant_name . 
  FILTER (?pollutant_name = 'Total GHG (Gg CO2 equivalent)')
  _:ghg_projections tableFile:scenario ?scenario . FILTER (?scenario = 'WEM')
  {
    _:ghg_projections tableFile:sector ?sector . 
    FILTER (?sector in ('Energy supply (1A1 + 1B)'))
    _:ghg_projections tableFile:emissions ?wem_energy_supply .
  } UNION {
    _:ghg_projections tableFile:sector ?sector . 
    FILTER (?sector in ('Energy use (1A2 + 1A4 + 1A5)'))
    _:ghg_projections tableFile:emissions ?wem_energy_use .
  } UNION {
    _:ghg_projections tableFile:sector ?sector . 
    FILTER (?sector in ('Transport - energy (1A3)'))
    _:ghg_projections tableFile:emissions ?wem_transport .
  } UNION {
    _:ghg_projections tableFile:sector ?sector . 
    FILTER (?sector in ('Agriculture (4)'))
    _:ghg_projections tableFile:emissions ?wem_agriculture .
  } UNION {
    _:ghg_projections tableFile:sector ?sector . 
    FILTER (?sector in ('Industrial processes (2)'))
    _:ghg_projections tableFile:emissions ?wem_industrial_processes .
  } UNION {
    _:ghg_projections tableFile:sector ?sector . 
    FILTER (?sector in ('Other (3 + 7)'))
    _:ghg_projections tableFile:emissions ?wem_solvents .
  } UNION {
    _:ghg_projections tableFile:sector ?sector . 
    FILTER (?sector in ('Waste (6)'))
    _:ghg_projections tableFile:emissions ?wem_waste .
  } 
}
GROUP BY ?date
ORDER BY ?date