Skip to content

Instantly share code, notes, and snippets.

@crssnky

crssnky/アイドルごとの総選挙での全獲得票数.sparql

Last active May 20, 2019 14:36
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/164b6f17b4abb410aae2b6288caebf83 to your computer and use it in GitHub Desktop.
Save crssnky/164b6f17b4abb410aae2b6288caebf83 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
アイドルごとの総選挙での全獲得票数.sparql
PREFIX imas: <https://sparql.crssnky.xyz/imasrdf/URIs/imas-schema.ttl#>
PREFIX schema: <http://schema.org/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT (SUM(?得票数) as ?総得票数) (Sample(?nm) as ?名前)
WHERE {
?s schema:member ?o;
imas:VoteNumber ?得票数.
?o rdfs:label ?nm
}group by(?o) order by(?総得票数)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment