Skip to content

Instantly share code, notes, and snippets.

@crssnky

crssnky/ユニットの平均身長を降順.sparql

Created January 28, 2018 09:31
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save crssnky/910f7cd2aff0b379c4a2e36f0cfe4094 to your computer and use it in GitHub Desktop.
Save crssnky/910f7cd2aff0b379c4a2e36f0cfe4094 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
ユニットの平均身長を降順.sparql
PREFIX schema: <http://schema.org/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX imas: <https://sparql.crssnky.xyz/imasrdf/URIs/imas-schema.ttl#>
SELECT ?ユニット名 (avg(?h) as ?平均身長)
WHERE {
?s rdf:type imas:Unit;
schema:name ?ユニット名;
schema:member ?m.
?m schema:height ?h.
}group by(?ユニット名) order by desc(?平均身長)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment