Marine aquaculture production relative to coastline length - total

PREFIX FishStatUnpivot: <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/>
PREFIX wri_coastline: <http://semantic.eea.europa.eu/project/CSI033/wri_coastline.tsv#>

select
xsd:integer(?year) as ?year
?country
'TOTAL' as ?group
?wri_coastline
round((sum(coalesce(xsd:double(?FishStatUnpivot),0))/?wri_coastline)*100)/100.0 as ?obsValue

round(sum(coalesce(xsd:double(?FishStatUnpivot),0))/10.0)/100.0 as ?FishStatUnpivot

{{
  SELECT DISTINCT
    ?year
    ?country
    ?iso2
    ?group
    ?FishStatUnpivot
    ?wri_coastline
  WHERE {
    _:FishStatUnpivot FishStatUnpivot:country ?country .
    _:FishStatUnpivot FishStatUnpivot:iso2 ?iso2 .
    _:FishStatUnpivot FishStatUnpivot:group ?group .
    _:FishStatUnpivot FishStatUnpivot:environment ?environment .
    _:FishStatUnpivot FishStatUnpivot:year ?year .
    _:FishStatUnpivot FishStatUnpivot:obsValue ?FishStatUnpivot .
    FILTER (?group IN ('PISCES', 'MOLLUSCA'))

    FILTER (?environment = 'Marine')
    FILTER (xsd:integer(?year) = 2017)
    OPTIONAL { ?member skos:notation ?iso2 }.
    OPTIONAL { ?member rdfs:label ?country } .

    _:wri_coastline wri_coastline:geo ?iso2 .
    _:wri_coastline wri_coastline:obsValue ?wri_coastline .
  }
}}
ORDER BY xsd:integer(?year) ?country ?environment