query-7446a921746ca29b0b468e2b9fbf22ae

rq turtle/ttl

Our question: Which universities of the country are recognised as higher education institutions (accredited, attested)? was not possible to create because there is not property in WIKIDATA for the accreditation of universities.The queries Which city offers a specific degree in a specific major in which city?does work even if there are some unclear things. . It seems to be the same but there are different results for each query. By playing around with the queries we noticed that very few universities have the property “grant”. For germany we get 658 universities but just less than ten have it. ( ?university wdt:P31 wd:Q3918 ) and if a “university is a university” ( ?university wdt:P31/wdt:P279* wd:Q38723 )We are not sure what the difference is between if a “university is an instance of a subclass of a higher education institution” Finally we decided to use the first version with higher education institution.

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
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/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?university ?universityLabel ?degreeLabel ?majorLabel ?cityLabel WHERE {
    SERVICE wikibase:label { bd:serviceParam wikibase:language
    "[AUTO_LANGUAGE],en". }
    ?university wdt:P31/wdt:P279* wd:Q38723;
            wdt:P17 wd:Q1027;# in country mauritius
            wdt:P131 ?city;
            p:P5460 ?statement .

    ?statement ps:P5460 ?degree .
    ?statement pq:P812 ?major .

  FILTER(?degree = wd:Q1765120) #bachelor of arts degree
  FILTER(?major = wd:Q16653334) #Law and management
  FILTER(?city = wd:Q282908 ) #Moka
}
ORDER BY ?universityLabel ?degreeLabel ?majorLabel

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?city") v6("?degree") v2("?degreeLabel"):::projected v5("?major") v3("?majorLabel"):::projected v8("?statement") v7("?university"):::projected v1("?universityLabel"):::projected a1((" ")) c5(["bd:serviceParam"]):::iri c7(["#91;AUTO_LANGUAGE#93;,en"]):::literal c10(["wd:Q38723"]):::iri c12(["wd:Q1027"]):::iri f0[["?city = 'wd:Q282908'"]] f0 --> v4 f1[["?major = 'wd:Q16653334'"]] f1 --> v5 f2[["?degree = 'wd:Q1765120'"]] f2 --> v6 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c5 --"wikibase:language"--> c7 end v7 --"p:direct/P31"--> a1 a1 --"p:direct/P279"--> c10 v7 --"p:direct/P17"--> c12 v7 --"p:direct/P131"--> v4 v7 --"p:P5460"--> v8 v8 --"p:statement/P5460"--> v6 v8 --"p:qualifier/P812"--> v5