Annual aquaculture production of main species

PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX tableFile: <http://semantic.eea.europa.eu/project/CSI033/FishStatUnpivot.csv#>
PREFIX countrygroups: <http://dd.eionet.europa.eu/vocabulary/common/countrygroups/>
PREFIX countries: <http://dd.eionet.europa.eu/vocabulary/common/countries/>

SELECT DISTINCT
?year 
?geoarea
?area
bif:either(?speciesGroup = 'PISCES', 'Miscellaneous fishes', ?speciesGroup) as ?species 
sum(?obsValue)/1000 as ?obsValue

WHERE {
  _:rec tableFile:iso2 ?iso2 .
  {
    _:rec tableFile:speciesGroup ?speciesGroup .
  } UNION {
    _:rec tableFile:species ?speciesGroup .
  } UNION {
    _:rec tableFile:group ?speciesGroup .
  }
  FILTER (?speciesGroup in ('Atlantic salmon', 'European seabass', 'Gilthead seabream', 
                            'Atlantic bluefin tuna', 'Sea trout', 'Rainbow trout', 
                            'European eel', 'Brown seaweeds', 'Mussels', 'Oysters',
                            'Carps, barbels and other cyprinids', 'PISCES'))
  _:rec tableFile:area ?area .
  _:rec tableFile:environment ?environment .
  _:rec tableFile:unit ?unit .
  _:rec tableFile:year ?year .
 
  ?member skos:notation ?iso2 .
  ?geoarea_uri skos:member ?member.
  ?geoarea_uri ?o countrygroups: .
  ?geoarea_uri skos:notation ?geoarea .
  _:rec tableFile:obsValue ?obsValue .
  FILTER (?geoarea_uri in (countrygroups:EU28, countrygroups:EEA39 ))

  FILTER (?year > 1992)
}
ORDER BY ?geoarea ?year ?group ?species ?area