משתמש:Yoavd/דוגמאות לשאילתות ויקי נתונים

הצגת ממוצע הגילאים של שחמטאים בדרגת רב אמן לפי ארצות.

SELECT ?country ?countryLabel (AVG(?age) AS ?averageAge) (GROUP_CONCAT(CONCAT(?grandmasterLabel, " (", STR(?yearOfBirth), "-", STR(?yearOfDeath), ")"); SEPARATOR=", ") AS ?grandmasters) WHERE {

 ?grandmaster wdt:P31 wd:Q5;        # instance of human
             wdt:P106 wd:Q10873124; # occupation: chess grandmaster
             wdt:P569 ?dateOfBirth; # date of birth
             wdt:P570 ?dateOfDeath; # date of death
             wdt:P27 ?country.      # country of citizenship
 
 FILTER(YEAR(?dateOfDeath) > 1950)
 
 BIND(YEAR(?dateOfBirth) AS ?yearOfBirth)
 BIND(YEAR(?dateOfDeath) AS ?yearOfDeath)
 
 BIND((YEAR(?dateOfDeath) - YEAR(?dateOfBirth)) AS ?age)
 
 SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

} GROUP BY ?country ?countryLabel

ORDER BY ?countryLabel

הצגת מספר ראשי ערים ממין נקבה לפי ארצות

SELECT ?country ?countryLabel (COUNT(?mayor) AS ?numWomenMayors) WHERE {

 ?mayor wdt:P31 wd:Q5;                  # instance of human
        wdt:P39 wd:Q30185;              # position held: mayor
        wdt:P21 wd:Q6581072;            # gender: female
        wdt:P27 ?country.               # country of citizenship
 
 SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

} GROUP BY ?country ?countryLabel

ORDER BY DESC(?numWomenMayors)

• מציאת רבי אמנים שאין להם ערך בויקיפדיה העברית

SELECT ?gm ?gmLabel (MAX(?rating) AS ?maxRating) WHERE {

 ?gm wdt:P31 wd:Q5;  # instance of human
     wdt:P106 wd:Q10873124;  # occupation: chess grandmaster
     wdt:P1087 ?rating.  # FIDE rating
 FILTER NOT EXISTS {
   ?article schema:about ?gm;
            schema:isPartOf <https://he.wikipedia.org/>.
 }
 SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

} GROUP BY ?gm ?gmLabel