Annual aquaculture production of main species

PREFIX tableFile: <http://semantic.eea.europa.eu/project/CSI033/FishStatUnpivot2019.tsv#>
PREFIX countrygroups: <http://dd.eionet.europa.eu/vocabulary/common/countrygroups/>
PREFIX countries: <http://dd.eionet.europa.eu/vocabulary/common/countries/>

SELECT DISTINCT
xsd:integer(?year) as ?year 
?geoarea
?area
bif:either(?speciesGroup = 'PISCES', 'Miscellaneous fishes', ?speciesGroup) as ?species 
round(sum(xsd:double(?obsValue))/10.0)/100.0 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:inScheme countries: .
  ?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 (xsd:integer(?year) > 1992)
}
ORDER BY ?geoarea xsd:integer(?year) ?group ?species ?area