משתמש: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)