query-bb5503c7beb1bfb678602fc8f5bdfa11

rq turtle/ttl

按年所属国家累计年统计得奖人数

Use at

• https://query.wikidata.org/sparql

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT * 


WHERE {
   {
SELECT ?year ?country ?human ?yearOther ?countryOther ?humanOther WHERE {
    ?human (p:P166) ?awardStatement.
    ?awardStatement ps:P166/wdt:P279* wd:Q7191.
          ?awardStatement pq:P585 ?date.
    ?human  wdt:P27 ?country.
    bind(str(YEAR(?date)) AS ?year)

    ?humanOther (p:P166) ?awardStatement.
      ?awardStatement ps:P166/wdt:P279* wd:Q7191.
          ?awardStatement pq:P585 ?date.
  ?humanOther  wdt:P27 ?countryOther.
   bind(str(YEAR(?date)) AS ?yearOther)
   FILTER (?year >= ?yearOther)
}
}
}
#GROUP BY ?year
ORDER BY ASC(?year)

Query found at

• https://www.wikidata.org/wiki/User:Bangbang.S