Primary and final energy consumption in the European Union

PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#> 
PREFIX sdmx-attribute: <http://purl.org/linked-data/sdmx/2009/attribute#> 
PREFIX property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX siec: <http://dd.eionet.europa.eu/vocabulary/eurostat/siec/>
PREFIX nrg_bal: <http://dd.eionet.europa.eu/vocabulary/eurostat/nrg_bal/>
PREFIX measure: <http://purl.org/linked-data/sdmx/2009/measure#>

SELECT DISTINCT
?date
ROUND(SUM(?PEC20202030)/1000) AS ?PEC20202030
ROUND(SUM(?FEC20202030)/1000) AS ?FEC20202030
SUM(?PECTARGET)/1000 AS ?PECTARGET
SUM(?FECTARGET)/1000 AS ?FECTARGET
  WHERE {
      {
      GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_bal_c.rdf.gz>
        {{
          _:nrg_bal_c sdmx-dimension:timePeriod ?date .
          _:nrg_bal_c sdmx-attribute:unitMeasure unit:KTOE .
          _:nrg_bal_c sdmx-dimension:refArea geo:EU27_2020 .
          _:nrg_bal_c property:siec siec:TOTAL .
          {
              _:nrg_bal_c property:nrg_bal nrg_bal:PEC2020-2030 .
              _:nrg_bal_c measure:obsValue ?PEC20202030 .
          } UNION {
              _:nrg_bal_c property:nrg_bal nrg_bal:FEC2020-2030 .
              _:nrg_bal_c measure:obsValue ?FEC20202030 .
          }
          


        }}
      } UNION {
        {
          SELECT xsd:date('2020-01-01') AS ?date
                 geo:EU27_2020 AS ?geo
                 1246000 AS ?PEC20202030
                 935000 AS ?FEC20202030
          WHERE {}
        }
      } UNION {
        {
          SELECT xsd:date('2020-01-01') AS ?date
                 geo:EU27_2020 AS ?geo
                 1305400 AS ?PECTARGET
                 956800 AS ?FECTARGET
          WHERE {}
        }
      } UNION {
        {
          SELECT xsd:date('2030-01-01') AS ?date
                 geo:EU27_2020 AS ?geo
                 1128000 AS ?PECTARGET
                 846000 AS ?FECTARGET
          WHERE {}
        }
      }
    }
ORDER BY DESC(?date)