Library of Visual QALD-9 queries over DBPedia

 

Jūlija Ovčiņņikova, Kārlis Čerāns

Institute of Mathematics and Computer Science, University of Latvia

 

Supported by the project lzp2021/1-0389 “Visual Queries in Distributed Knowledge Graphs” by Latvian Council of Science

 

The data set is obtained by means of visualization of existing SPARQL queries

from the QALD-9 test dataset used originally in the context of natural language query answering.

 

Source data: https://github.com/ag-sc/QALD/blob/master/9/data/qald-9-test-multilingual.json

 

150 queries that have textual formulations in English are included in the data set.

 

The queries are meant for executing over the DBPedia data endpoint: https://dbpedia.org/sparql/

 

Nr

Question

SPARQL Query

ViziQuer to SPARQL

ViziQuer

Comment

1

What is the revenue of IBM?

PREFIX res: <http://dbpedia.org/resource/>

PREFIX onto: <http://dbpedia.org/ontology/>

SELECT ?number WHERE {

  res:IBM onto:revenue ?number

}

# ID = 1,

# Question = What is the revenue of IBM?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT ?revenue WHERE{

  dbr:IBM dbo:revenue ?revenue.

}

 

 

OK

 

No results

4

Which airports are located in California, USA?

SELECT DISTINCT ?uri WHERE { ?uri a <http://dbpedia.org/ontology/Airport> { ?uri <http://dbpedia.org/ontology/location> <http://dbpedia.org/resource/California> } UNION { ?uri <http://dbpedia.org/ontology/city> <http://dbpedia.org/resource/California> } UNION { ?uri <http://dbpedia.org/ontology/city> ?city . ?city <http://dbpedia.org/ontology/isPartOf> <http://dbpedia.org/resource/California> } UNION { ?uri <http://dbpedia.org/ontology/operator> <http://dbpedia.org/resource/California> } }

# ID = 4,

# Question = Which airports are located in California, USA?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  ?uri a dbo:Airport.

  ?uri dbo:location|dbo:city|dbo:city/dbo:isPartOf|dbo:operator dbr:California.

}

 

OK

6

Are Taiko some kind of Japanese musical instrument?

ASK WHERE { <http://dbpedia.org/resource/Taiko> a <http://dbpedia.org/class/yago/WikicatJapaneseMusicalInstruments> }

# ID = 6,

# Question = Are Taiko some kind of Japanese musical instrument?

PREFIX yago: <http://dbpedia.org/class/yago/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT ?WikicatJapaneseMusicalInstruments WHERE{

  ?WikicatJapaneseMusicalInstruments a yago:WikicatJapaneseMusicalInstruments.

  FILTER(?WikicatJapaneseMusicalInstruments = dbr:Taiko)

}

LIMIT 1

 

OK

 

ASK

7

Give me all cars that are produced in Germany.

SELECT DISTINCT ?uri WHERE {

  ?uri a <http://dbpedia.org/ontology/Automobile>

    { ?uri <http://dbpedia.org/ontology/assembly> <http://dbpedia.org/resource/Germany> }

  UNION

  { ?uri <http://dbpedia.org/property/assembly> <http://dbpedia.org/resource/Germany> }

  UNION {

    { ?uri <http://dbpedia.org/ontology/manufacturer> ?x }

    UNION

    { ?uri <http://dbpedia.org/property/manufacturer> ?x }

   

    { ?x <http://dbpedia.org/ontology/locationCountry> <http://dbpedia.org/resource/Germany> }

    UNION

    { ?x <http://dbpedia.org/ontology/location> <http://dbpedia.org/resource/Germany> }

  }

}

# ID = 7,

# Question = Give me all cars that are produced in Germany,

#

# Manually edited

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbp: <http://dbpedia.org/property/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  ?uri a dbo:Automobile.

  {

    ?uri a dbo:Automobile.

    ?uri dbo:assembly dbr:Germany.

  }

  UNION

  {

    ?uri a dbo:Automobile.

    {

    ?x dbo:location dbr:Germany.

  }

  UNION

  {

    ?x dbo:locationCountry dbr:Germany.

  }

    {

    ?uri dbo:manufacturer ?x.

  }

  UNION

  {

    ?uri dbp:manufacturer ?x.

  }

  }

  UNION

  {

    ?uri a dbo:Automobile.

    ?uri dbp:assembly dbr:Germany.

  }

}

 

Manually edited

 

TO DO:

UNION

8

Who founded Intel?

SELECT DISTINCT ?uri WHERE { <http://dbpedia.org/resource/Intel> <http://dbpedia.org/property/founders> ?uri }

# ID = 8,

# Question = Who founded Intel?

PREFIX dbp: <http://dbpedia.org/property/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?founders WHERE{

  dbr:Intel dbp:founders ?founders.

}

 

 

OK

9

In which city is the headquarter of Air China?

SELECT DISTINCT ?uri WHERE { <http://dbpedia.org/resource/Air_China> <http://dbpedia.org/ontology/headquarter> ?uri . ?uri a <http://dbpedia.org/class/yago/City108524735> }

# ID = 9,

# Question = In which city is the headquarter of Air China?

PREFIX yago: <http://dbpedia.org/class/yago/>

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  dbr:Air_China dbo:headquarter ?uri.

  ?uri a yago:City108524735.

}

 

 

OK

10

How many students does the Free University of Amsterdam have?

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?num WHERE { dbr:Vrije_Universiteit_Amsterdam <http://dbpedia.org/ontology/numberOfStudents> ?num }

# ID = 10,

# Question = How many students does the Free University of Amsterdam have?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?numberOfStudents WHERE{

  dbr:Vrije_Universiteit_Amsterdam dbo:numberOfStudents ?numberOfStudents.

}

 

 

OK

 

No results

13

Which politicians were married to a German?

SELECT DISTINCT ?uri WHERE {

?uri a <http://dbpedia.org/ontology/Politician> ; <http://dbpedia.org/ontology/spouse> ?spouse

{ ?spouse <http://dbpedia.org/ontology/birthPlace> <http://dbpedia.org/resource/Germany> }

UNION

{ ?spouse <http://dbpedia.org/ontology/birthPlace> ?p . ?p <http://dbpedia.org/ontology/country> <http://dbpedia.org/resource/Germany> }

 

}

# ID = 13,

# Question = Which politicians were married to a German?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  ?uri a dbo:Politician.

  ?uri dbo:spouse ?spouse.

  ?spouse dbo:birthPlace|dbo:birthPlace/dbo:country dbr:Germany.

}

 

 

 

OK

14

Show me hiking trails in the Grand Canyon where there's no danger of flash floods.

SELECT DISTINCT ?uri WHERE { ?uri <http://dbpedia.org/property/trailheads> <http://dbpedia.org/resource/Grand_Canyon> FILTER NOT EXISTS { ?uri <http://dbpedia.org/property/hazards> <http://dbpedia.org/resource/Flash_flood> } }

# ID = 14,

# Question = Show me hiking trails in the Grand Canyon where there's no danger of flash floods.

PREFIX dbp: <http://dbpedia.org/property/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  ?uri dbp:trailheads dbr:Grand_Canyon.

  FILTER(NOT EXISTS{?uri dbp:hazards ?hazards. })

}

 

 

OK

 

15

How short is the shortest active NBA player?

SELECT DISTINCT ?n WHERE {

  ?x a <http://dbpedia.org/ontology/BasketballPlayer> ;

    <http://dbpedia.org/ontology/league> <http://dbpedia.org/resource/National_Basketball_Association> ;

    <http://dbpedia.org/ontology/height> ?n

    FILTER NOT EXISTS { ?x <http://dbpedia.org/ontology/activeYearsEndYear> ?d }

} ORDER BY ASC(?n) OFFSET 0 LIMIT 1

# ID = 15,

# Question = How short is the shortest active NBA player?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?n WHERE{

  ?x a dbo:BasketballPlayer.

  ?x dbo:league dbr:National_Basketball_Association.

  ?x dbo:height ?n.

  FILTER(NOT EXISTS{?x dbo:activeYearsEndYear ?ctiveYearsEndYea. })

}

ORDER BY ?n

LIMIT 1

 

 

OK

19

Who became president after JFK died?

SELECT DISTINCT ?uri WHERE {

  <http://dbpedia.org/resource/John_F._Kennedy> <http://dbpedia.org/property/presidentEnd> ?x .

  ?uri <http://dbpedia.org/property/presidentStart> ?x;

    a <http://dbpedia.org/ontology/Person>.

}

# ID = 19,

# Question = Who became president after JFK died?

PREFIX dbp: <http://dbpedia.org/property/>

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  ?uri a dbo:Person.

  dbr:John_F._Kennedy dbp:presidentEnd ?x.

  ?uri dbp:presidentStart ?x.

}

 

 

OK

 

No results

20

How many calories does a baguette have?

SELECT DISTINCT ?n WHERE { <http://dbpedia.org/resource/Baguette> <http://dbpedia.org/property/calories> ?n }

# ID = 20,

# Question = How many calories does a baguette have?

PREFIX dbp: <http://dbpedia.org/property/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?calories WHERE{

  dbr:Baguette dbp:calories ?calories.

}

 

 

OK

21

Who created English Wikipedia?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX onto: <http://dbpedia.org/ontology/> SELECT ?uri WHERE { <http://dbpedia.org/resource/Wikipedia> onto:author ?uri }

# ID = 21,

# Question = Who created English Wikipedia?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT ?author WHERE{

  dbr:Wikipedia dbo:author ?author.

}

 

 

OK

22

How many grand-children did Jacques Cousteau have?

SELECT (COUNT(DISTINCT ?y) AS ?y) WHERE { <http://dbpedia.org/resource/Jacques_Cousteau> <http://dbpedia.org/ontology/child> ?x . ?x <http://dbpedia.org/ontology/child> ?y . }

# ID = 22,

# Question = How many grand-children did Jacques Cousteau have?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT (COUNT(DISTINCT ?y) AS ?y) WHERE{

  ?x dbo:child ?y.

  dbr:Jacques_Cousteau dbo:child ?x.

}

 

 

 

OK

23

Which software has been published by Mean Hamster Software?

PREFIX res: <http://dbpedia.org/resource/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX onto: <http://dbpedia.org/ontology/> PREFIX prop: <http://dbpedia.org/property/> SELECT DISTINCT ?uri WHERE { ?uri rdf:type onto:Software { ?uri prop:publisher "Mean Hamster Software"@en } UNION { ?uri onto:publisher res:Mean_Hamster_Software } }

# ID = 23,

# Question = Which software has been published by Mean Hamster Software?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbp: <http://dbpedia.org/property/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  ?uri a dbo:Software.

  {

    ?uri a dbo:Software.

    ?uri dbp:publisher "Mean Hamster Software"@en .

  }

  UNION

  {

    ?uri a dbo:Software.

    ?uri dbo:publisher dbr:Mean_Hamster_Software.

  }

}

 

 

OK

24

How many emperors did China have?

SELECT (COUNT(DISTINCT ?uri) AS ?uri) WHERE { ?uri <http://dbpedia.org/property/title> <http://dbpedia.org/resource/Emperor_of_China> . }

# ID = 24,

# Question = How many emperors did China have?

PREFIX dbp: <http://dbpedia.org/property/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT (COUNT(DISTINCT ?uri) AS ?uri) WHERE{

  ?uri dbp:title dbr:Emperor_of_China.

}

 

 

OK

25

What is the longest river in China?

SELECT DISTINCT ?uri WHERE { ?uri a <http://dbpedia.org/ontology/River> ; <http://dbpedia.org/ontology/country> <http://dbpedia.org/resource/China> ; <http://dbpedia.org/property/length> ?l } ORDER BY DESC(?l) OFFSET 0 LIMIT 1

# ID = 25,

# Question = What is the longest river in China?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbp: <http://dbpedia.org/property/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  ?uri a dbo:River.

  ?uri dbo:country dbr:China.

  ?uri dbp:length ?l.

}

ORDER BY DESC(?l)

LIMIT 1

 

 

OK

26

What is the atmosphere of the Moon composed of?

SELECT DISTINCT ?uri WHERE { <http://dbpedia.org/resource/Moon> <http://dbpedia.org/property/atmosphereComposition> ?uri }

# ID = 26,

# Question = What is the atmosphere of the Moon composed of?

PREFIX dbp: <http://dbpedia.org/property/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?atmosphereComposition WHERE{

  dbr:Moon dbp:atmosphereComposition ?atmosphereComposition.

}

 

OK

27

Which rivers flow into the North Sea?

SELECT DISTINCT ?uri WHERE { ?uri a <http://dbpedia.org/ontology/River> ; <http://dbpedia.org/ontology/riverMouth> <http://dbpedia.org/resource/North_Sea> }

# ID = 27,

# Question = Which rivers flow into the North Sea?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  ?uri a dbo:River.

  ?uri dbo:riverMouth dbr:North_Sea.

}

 

 

OK

29

Which countries in the European Union adopted the Euro?

SELECT DISTINCT ?uri WHERE { ?uri a <http://dbpedia.org/ontology/Country> { ?uri <http://dbpedia.org/ontology/currency> <http://dbpedia.org/resource/Euro> } UNION { ?uri <http://dbpedia.org/property/currencyCode> "EUR"@en } }

# ID = 29,

# Question = Which countries in the European Union adopted the Euro?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbp: <http://dbpedia.org/property/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  ?uri a dbo:Country.

  {

    ?uri a dbo:Country.

    ?uri dbo:currency dbr:Euro.

  }

  UNION

  {

    ?uri a dbo:Country.

    ?uri dbp:currencyCode "EUR"@en .

  }

}

 

 

OK

31

Who is the mayor of Berlin?

PREFIX dbp: <http://dbpedia.org/property/>

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX res: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE { res:Berlin dbp:leader ?uri }

# ID = 31,

# Question = Who is the mayor of Berlin?

PREFIX dbp: <http://dbpedia.org/property/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?leader WHERE{

  dbr:Berlin dbp:leader ?leader.

}

 

OK

 

No results

32

What is Angela Merkel’s birth name?

PREFIX res: <http://dbpedia.org/resource/> PREFIX dbp: <http://dbpedia.org/property/> SELECT DISTINCT ?string WHERE { res:Angela_Merkel dbp:birthName ?string }

# ID = 32,

# Question = What is Angela Merkel’s birth name?

PREFIX dbp: <http://dbpedia.org/property/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?birthName WHERE{

  dbr:Angela_Merkel dbp:birthName ?birthName.

}

 

OK

34

Give me all female German chancellors.

PREFIX res: <http://dbpedia.org/resource/> PREFIX dbp: <http://dbpedia.org/property/> SELECT DISTINCT ?uri WHERE { res:Chancellor_of_Germany dbp:incumbent ?uri }

# ID = 34,

# Question = Give me all female German chancellors.

PREFIX dbp: <http://dbpedia.org/property/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?incumbent WHERE{

  dbr:Chancellor_of_Germany dbp:incumbent ?incumbent.

}

 

OK

37

What are the nicknames of San Francisco?

PREFIX res: <http://dbpedia.org/resource/> PREFIX dbp: <http://dbpedia.org/property/> PREFIX foaf:<http://xmlns.com/foaf/0.1/> SELECT DISTINCT ?string WHERE { res:San_Francisco foaf:nick ?string }

# ID = 37,

# Question = What are the nicknames of San Francisco?

PREFIX foaf: <http://xmlns.com/foaf/0.1/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?nick WHERE{

  dbr:San_Francisco foaf:nick ?nick.

}

 

 

OK

38

Give me all Frisian islands that belong to the Netherlands.

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX yago: <http://dbpedia.org/class/yago/> PREFIX res: <http://dbpedia.org/resource/> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> SELECT DISTINCT ?uri WHERE { ?uri rdf:type yago:WikicatFrisianIslands ; dbo:country res:Netherlands }

# ID = 38,

# Question = Give me all Frisian islands that belong to the Netherlands.

PREFIX yago: <http://dbpedia.org/class/yago/>

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  ?uri a yago:WikicatFrisianIslands.

  ?uri dbo:country dbr:Netherlands.

}

 

 

OK

39

Which poet wrote the most books?

SELECT DISTINCT ?uri WHERE { ?uri <http://dbpedia.org/ontology/occupation> <http://dbpedia.org/resource/Poet> . ?x <http://dbpedia.org/ontology/author> ?uri . ?x <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://dbpedia.org/ontology/Book> . } ORDER BY DESC(COUNT(?x)) OFFSET 0 LIMIT 1

# ID = 39,

# Question = Which poet wrote the most books?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  ?uri dbo:occupation dbr:Poet.

  ?x dbo:author ?uri.

  ?x a dbo:Book.

}

ORDER BY DESC(COUNT(?x))

LIMIT 1

 

 

 

OK

40

Who were the parents of Queen Victoria?

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX res: <http://dbpedia.org/resource/> SELECT DISTINCT ?uri WHERE { res:Queen_Victoria dbo:parent ?uri }

# ID = 40,

# Question = Who were the parents of Queen Victoria?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?parent WHERE{

  dbr:Queen_Victoria dbo:parent ?parent.

}

 

 

OK

42

Which countries have places with more than two caves?

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> SELECT DISTINCT ?uri WHERE { ?cave rdf:type dbo:Cave ; dbo:location ?uri . ?uri rdf:type dbo:Country } GROUP BY ?uri HAVING ( COUNT(?cave) > 2 )

# ID = 42,

# Question = Which countries have places with more than two caves?

#

# Manually edited

PREFIX dbo: <http://dbpedia.org/ontology/>

SELECT ?uri WHERE{

  {SELECT ?uri (COUNT(?cave) AS ?c) WHERE{

    ?cave a dbo:Cave.

    ?uri a dbo:Country.

    ?cave dbo:location ?uri.}

    GROUP BY ?uri

  }

  FILTER(?c >= 2)

}

 

Manually edited

 

TO DO:

HAVING

43

Give me the websites of companies with more than 500000 employees.

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX foaf: <http://xmlns.com/foaf/0.1/> PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> SELECT distinct ?web WHERE { ?sub dbo:numberOfEmployees ?obj . ?sub foaf:homepage ?web FILTER( xsd:integer(?obj) > 500000 ) . }

# ID = 43,

# Question = Give me the websites of companies with more than 500000 employees.

PREFIX foaf: <http://xmlns.com/foaf/0.1/>

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>

PREFIX dbo: <http://dbpedia.org/ontology/>

SELECT DISTINCT ?homepage WHERE{

  ?sub foaf:homepage ?homepage.

  ?sub dbo:numberOfEmployees ?numberOfEmployees.

  BIND(xsd:integer(?numberOfEmployees) AS ?expr_1)

  FILTER(?expr_1 > 500000)

}

 

OK

44

Which European countries have a constitutional monarchy?

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX dct: <http://purl.org/dc/terms/> PREFIX dbc: <http://dbpedia.org/resource/Category:> PREFIX dbr: <http://dbpedia.org/resource/> SELECT ?uri WHERE {

?uri dct:subject dbc:Countries_in_Europe ; dbo:governmentType dbr:Constitutional_monarchy }

# ID = 44,

# Question = Which European countries have a constitutional monarchy?

PREFIX dct: <http://purl.org/dc/terms/>

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT ?uri WHERE{

  ?uri dct:subject dbr:Category:Countries_in_Europe.

  ?uri dbo:governmentType dbr:Constitutional_monarchy.

}

 

 

OK

45

Where did Abraham Lincoln die?

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX res: <http://dbpedia.org/resource/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> SELECT DISTINCT ?uri WHERE { res:Abraham_Lincoln dbo:deathPlace ?uri }

# ID = 45,

# Question = Where did Abraham Lincoln die?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?deathPlace WHERE{

  dbr:Abraham_Lincoln dbo:deathPlace ?deathPlace.

}

 

 

 

OK

49

Which frequent flyer program has the most airlines?

SELECT ?uri WHERE { ?airline <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://dbpedia.org/ontology/Airline> . ?airline <http://dbpedia.org/property/frequentFlyer> ?uri. } GROUP BY ?uri ORDER BY DESC(COUNT(DISTINCT ?airline)) OFFSET 0 LIMIT 1

# ID = 49,

# Question = Which frequent flyer program has the most airlines?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbp: <http://dbpedia.org/property/>

SELECT ?uri WHERE{

  ?airline a dbo:Airline.

  ?airline dbp:frequentFlyer ?uri.

 

}

ORDER BY DESC(COUNT(DISTINCT ?airline))

LIMIT 1

 

 

OK

50

What is the highest volcano in Africa?

PREFIX dbc: <http://dbpedia.org/resource/Category:>

PREFIX dct: <http://purl.org/dc/terms/>

SELECT DISTINCT ?uri WHERE { ?uri a <http://dbpedia.org/ontology/Volcano> ; <http://dbpedia.org/ontology/locatedInArea> ?area . ?area dct:subject dbc:Countries_in_Africa . ?uri <http://dbpedia.org/ontology/elevation> ?elevation } ORDER BY DESC(?elevation) LIMIT 1

# ID = 50,

# Question = What is the highest volcano in Africa?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dct: <http://purl.org/dc/terms/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  ?uri a dbo:Volcano.

  ?uri dbo:locatedInArea ?area.

  ?area dct:subject dbr:Category:Countries_in_Africa.

  ?uri dbo:elevation ?elevation.

}

ORDER BY DESC(?elevation)

LIMIT 1

 

 

OK

51

When is the movie Worst Case Scenario going to be in cinemas in the Netherlands?

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX dbr: <http://dbpedia.org/resource/> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX foaf: <http://xmlns.com/foaf/0.1/> SELECT DISTINCT ?rel WHERE { <http://dbpedia.org/resource/Worst_Case_Scenario_(film)> ?p ?o ; dbo:releaseDate ?rel FILTER contains(lcase(str(?o)), "netherlands") }

# ID = 51,

# Question = When is the movie Worst Case Scenario going to be in cinemas in the Netherlands?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?releaseDate WHERE{

  <http://dbpedia.org/resource/Worst_Case_Scenario_(film)> ?p ?o.

  <http://dbpedia.org/resource/Worst_Case_Scenario_(film)> dbo:releaseDate ?releaseDate.

  FILTER(CONTAINS(LCASE(STR(?o)), "netherlands"))

}

 

 

OK

52

Give me all movies with Tom Cruise.

PREFIX res: <http://dbpedia.org/resource/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX onto: <http://dbpedia.org/ontology/> PREFIX prop: <http://dbpedia.org/property/> SELECT DISTINCT ?uri WHERE {

?uri rdf:type onto:Film

{ ?uri prop:starring res:Tom_Cruise }

UNION { ?uri onto:starring res:Tom_Cruise }

 

OPTIONAL { ?uri rdfs:label ?string FILTER ( lang(?string) = "en" ) } }

# ID = 52,

# Question = Give me all movies with Tom Cruise.

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

PREFIX dbp: <http://dbpedia.org/property/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  ?uri a dbo:Film.

  ?uri dbp:starring|dbo:starring dbr:Tom_Cruise.

  OPTIONAL{?uri rdfs:label ?string. FILTER(LANG(?string) = 'en')}

}

 

 

OK

56

How many seats does the home stadium of FC Porto have?

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX dbp: <http://dbpedia.org/property/> PREFIX dbr: <http://dbpedia.org/resource/> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX db: <http://dbpedia.org/> SELECT ?capacity WHERE { { dbr:FC_Porto dbo:ground ?ground . ?ground dbo:capacity ?capacity } UNION { dbr:FC_Porto dbo:ground ?ground . ?ground dbp:capacity ?capacity } }

# ID = 56,

# Question = How many seats does the home stadium of FC Porto have?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbp: <http://dbpedia.org/property/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT ?capacity WHERE{

  dbr:FC_Porto dbo:ground/dbo:capacity|dbo:ground/dbp:capacity ?capacity.

}

 

 

OK

59

Which space probes were sent into orbit around the sun?

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX dbc: <http://dbpedia.org/resource/Category:> PREFIX dct: <http://purl.org/dc/terms/> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> SELECT DISTINCT ?s WHERE

{ ?s dct:subject dbc:Missions_to_the_Sun ; rdf:type ?type

 

FILTER ( ?type IN (dbo:Satellite, dbo:ArtificialSatellite) ) }

# ID = 59,

# Question = Which space probes were sent into orbit around the sun?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dct: <http://purl.org/dc/terms/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?s WHERE{

  ?s a ?type.

  ?s dct:subject dbr:Category:Missions_to_the_Sun.

  FILTER(?type IN (dbo:Satellite, dbo:ArtificialSatellite))

}

 

 

 

OK

60

Who is the governor of Texas?

PREFIX res: <http://dbpedia.org/resource/> PREFIX dbp: <http://dbpedia.org/property/> SELECT DISTINCT ?string WHERE { res:Texas dbp:governor ?string }

# ID = 60,

# Question = Who is the governor of Texas?

PREFIX dbp: <http://dbpedia.org/property/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?governor WHERE{

  dbr:Texas dbp:governor ?governor.

}

 

OK

62

What is the highest place of Karakoram?

PREFIX dbp: <http://dbpedia.org/property/>

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX res: <http://dbpedia.org/resource/> SELECT DISTINCT ?uri WHERE { res:Karakoram dbp:highest ?uri }

# ID = 62,

# Question = What is the highest place of Karakoram?

PREFIX dbp: <http://dbpedia.org/property/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?highest WHERE{

  dbr:Karakoram dbp:highest ?highest.

}

 

 

OK

63

Who was called Scarface?

PREFIX dbo: <http://dbpedia.org/ontology/> SELECT ?uri WHERE { ?uri dbo:alias ?alias FILTER contains(lcase(?alias), "scarface") }

# ID = 63,

# Question = Who was called Scarface?

PREFIX dbo: <http://dbpedia.org/ontology/>

SELECT ?uri WHERE{

  ?uri dbo:alias ?alias.

  FILTER(CONTAINS(LCASE(?alias), "scarface"))

}

 

 

OK

64

What is the profession of Frank Herbert?

PREFIX dbpedia2: <http://dbpedia.org/property/> PREFIX res: <http://dbpedia.org/resource/> SELECT DISTINCT ?string WHERE { res:Frank_Herbert dbpedia2:occupation ?string }

# ID = 64,

# Question = What is the profession of Frank Herbert?

PREFIX dbp: <http://dbpedia.org/property/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?occupation WHERE{

  dbr:Frank_Herbert dbp:occupation ?occupation.

}

 

 

OK

66

Which artists were born on the same date as Rachel Stevens?

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX dbr: <http://dbpedia.org/resource/> SELECT DISTINCT ?uri WHERE { ?uri a dbo:Artist . dbr:Rachel_Stevens dbo:birthDate ?birthdate . ?uri dbo:birthDate ?birthdate }

# ID = 66,

# Question = Which artists were born on the same date as Rachel Stevens?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  ?uri a dbo:Artist.

  ?uri dbo:birthDate ?birthdate.

  dbr:Rachel_Stevens dbo:birthDate ?birthdate.

}

 

 

OK

68

Which country was Bill Gates born in?

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX dbr: <http://dbpedia.org/resource/> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> SELECT DISTINCT ?country WHERE { { dbr:Bill_Gates dbo:birthPlace ?birthPlace . ?birthPlace dbo:country ?country } UNION { dbr:Bill_Gates dbo:birthPlace ?birthPlace . ?birthPlace dbo:isPartOf ?place . ?place dbo:country ?country } }

# ID = 68,

# Question = Which country was Bill Gates born in?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?country WHERE{

  dbr:Bill_Gates dbo:birthPlace/dbo:country|dbo:birthPlace/dbo:isPartOf/dbo:country ?country.

}

 

 

OK

71

Give me all spacecrafts that flew to Mars.

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX dbc: <http://dbpedia.org/resource/Category:> PREFIX dct: <http://purl.org/dc/terms/> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> SELECT DISTINCT ?s WHERE { ?s dct:subject dbc:Mars_rovers ; rdf:type ?type FILTER ( ?type IN (dbo:Satellite, dbo:ArtificialSatellite) ) }

# ID = 71,

# Question = Give me all spacecrafts that flew to Mars.

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dct: <http://purl.org/dc/terms/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?s WHERE{

  ?s a ?type.

  ?s dct:subject dbr:Category:Mars_rovers.

  FILTER(?type IN (dbo:Satellite, dbo:ArtificialSatellite))

}

 

 

 

OK

73

How many gold medals did Michael Phelps win at the 2008 Olympics?

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX dbr: <http://dbpedia.org/resource/> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> SELECT (Count(?sub) as ?c) WHERE { ?sub dbo:goldMedalist dbr:Michael_Phelps . filter (contains (str(?sub), "2008") && contains (str(?sub), "Olympics")) }

# ID = 73,

# Question = How many gold medals did Michael Phelps win at the 2008 Olympics?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT (COUNT(?sub) AS ?c) WHERE{

  ?sub dbo:goldMedalist dbr:Michael_Phelps.

  FILTER(CONTAINS(STR(?sub), "2008") && CONTAINS(STR(?sub), "Olympics"))

}

 

 

OK

78

When was the De Beers company founded?

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX res: <http://dbpedia.org/resource/> SELECT DISTINCT (xsd:date(?date) as ?date) WHERE { res:De_Beers dbo:foundingYear ?date }

# ID = 78,

# Question = When was the De Beers company founded?

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?date WHERE{

  dbr:De_Beers dbo:foundingYear ?foundingYear.

  BIND(xsd:date(?foundingYear) AS ?date)

}

 

OK

79

Are there any castles in the United States?

PREFIX dct: <http://purl.org/dc/terms/> PREFIX dbc: <http://dbpedia.org/resource/Category:> ASK WHERE { ?uri dct:subject dbc:Castles_in_the_United_States }

# ID = 79,

# Question = Are there any castles in the United States?

PREFIX dct: <http://purl.org/dc/terms/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT ?uri WHERE{

  ?uri dct:subject dbr:Category:Castles_in_the_United_States.

}

LIMIT 1

 

 

OK

 

ASK

80

Give me a list of all critically endangered birds.

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX dct: <http://purl.org/dc/terms/> PREFIX dbc: <http://dbpedia.org/resource/Category:> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> SELECT DISTINCT ?uri WHERE { ?uri rdf:type dbo:Bird { ?uri dbo:conservationStatus "CR" } UNION { ?uri dct:subject dbc:Critically_endangered_animals } }

# ID = 80,

# Question = Give me a list of all critically endangered birds.

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dct: <http://purl.org/dc/terms/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  ?uri a dbo:Bird.

  {

    ?uri a dbo:Bird.

    ?uri dbo:conservationStatus "CR" .

  }

  UNION

  {

    ?uri a dbo:Bird.

    ?uri dct:subject dbr:Category:Critically_endangered_animals.

  }

}

 

 

OK

81

Butch Otter is the governor of which U.S. state?

SELECT DISTINCT ?uri WHERE { ?uri a <http://dbpedia.org/class/yago/WikicatStatesOfTheUnitedStates> ; <http://dbpedia.org/property/governor> <http://dbpedia.org/resource/Butch_Otter> }

# ID = 81,

# Question = Butch Otter is the governor of which U.S. state?

PREFIX yago: <http://dbpedia.org/class/yago/>

PREFIX dbp: <http://dbpedia.org/property/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  ?uri a yago:WikicatStatesOfTheUnitedStates.

  ?uri dbp:governor dbr:Butch_Otter.

}

 

 

OK

 

No results

 

82

When was Jack Wolfskin founded?

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX res: <http://dbpedia.org/resource/> SELECT DISTINCT (xsd:date(?year) as ?y) WHERE { res:Jack_Wolfskin dbo:foundingYear ?year }

# ID = 82,

# Question = When was Jack Wolfskin founded?

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?y WHERE{

  dbr:Jack_Wolfskin dbo:foundingYear ?foundingYear.

  BIND(xsd:date(?foundingYear) AS ?y)

}

 

 

OK

83

Give me all gangsters from the prohibition era.

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX dct: <http://purl.org/dc/terms/> PREFIX dbc: <http://dbpedia.org/resource/Category:> PREFIX dbr: <http://dbpedia.org/resource/> SELECT DISTINCT ?uri WHERE { ?uri dbo:occupation dbr:Gangster ; dct:subject dbc:Prohibition-era_gangsters }

# ID = 83,

# Question = Give me all gangsters from the prohibition era.

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dct: <http://purl.org/dc/terms/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  ?uri dbo:occupation dbr:Gangster.

  ?uri dct:subject dbr:Category:Prohibition-era_gangsters.

}

 

 

OK

84

Which American presidents were in office during the Vietnam War?

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX res: <http://dbpedia.org/resource/> PREFIX dct: <http://purl.org/dc/terms/> PREFIX dbc: <http://dbpedia.org/resource/Category:> SELECT ?uri WHERE { ?uri dct:subject dbc:Presidents_of_the_United_States . res:Vietnam_War dbo:commander ?uri }

# ID = 84,

# Question = Which American presidents were in office during the Vietnam War?

PREFIX dct: <http://purl.org/dc/terms/>

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT ?uri WHERE{

  ?uri dct:subject dbr:Category:Presidents_of_the_United_States.

  dbr:Vietnam_War dbo:commander ?uri.

}

 

 

OK

86

What is the highest mountain in Germany?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX onto: <http://dbpedia.org/ontology/> SELECT ?uri WHERE { ?uri rdf:type onto:Mountain ; onto:elevation ?elevation ; onto:locatedInArea <http://dbpedia.org/resource/Germany> } ORDER BY DESC(?elevation) LIMIT 1

# ID = 86,

# Question = What is the highest mountain in Germany?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT ?uri WHERE{

  ?uri a dbo:Mountain.

  ?uri dbo:locatedInArea dbr:Germany.

  ?uri dbo:elevation ?elevation.

}

ORDER BY DESC(?elevation)

LIMIT 1

 

 

OK

87

Which book has the most pages?

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> SELECT DISTINCT ?uri WHERE { ?uri rdf:type dbo:Book ; dbo:numberOfPages ?n } ORDER BY DESC(?n) OFFSET 0 LIMIT 1

# ID = 87,

# Question = Which book has the most pages?

PREFIX dbo: <http://dbpedia.org/ontology/>

SELECT DISTINCT ?uri WHERE{

  ?uri a dbo:Book.

  ?uri dbo:numberOfPages ?numberOfPages.

}

ORDER BY DESC(?numberOfPages)

LIMIT 1

 

 

OK

88

What is the wavelength of Indigo?

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX dbr: <http://dbpedia.org/resource/> SELECT ?n WHERE { dbr:Indigo dbo:wavelength ?n }

# ID = 88,

# Question = What is the wavelength of Indigo?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT ?wavelength WHERE{

  dbr:Indigo dbo:wavelength ?wavelength.

}

 

OK

92

Is the wife of President Obama called Michelle?

PREFIX res: <http://dbpedia.org/resource/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX onto: <http://dbpedia.org/ontology/> ASK WHERE { res:Barack_Obama onto:spouse ?spouse . ?spouse rdfs:label ?name FILTER regex(?name, "Michelle") }

# ID = 92,

# Question = Is the wife of President Obama called Michelle?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

SELECT ?expr WHERE{

  ?expr dbo:spouse ?spouse.

  ?expr dbo:name ?name.

  ?spouse rdfs:label ?name.

  FILTER(REGEX(?name, "Michelle"))

  FILTER(?expr = dbr:Barack_Obama)

}

LIMIT 1

 

 

OK

 

ASK

94

When did princess Diana die?

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> SELECT DISTINCT (xsd:date(?d) as ?dd) WHERE { <http://dbpedia.org/resource/Diana,_Princess_of_Wales> <http://dbpedia.org/ontology/deathDate> ?d }

# ID = 94,

# Question = When did princess Diana die?

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>

PREFIX dbo: <http://dbpedia.org/ontology/>

SELECT DISTINCT ?dd WHERE{

  <http://dbpedia.org/resource/Diana\,_Princess_of_Wales> dbo:deathDate ?deathDate.

  BIND(xsd:date(?deathDate) AS ?dd)

}

 

 

OK

 

No results

 

95

Who is the youngest player in the Premier League?

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX res: <http://dbpedia.org/resource/> SELECT DISTINCT ?uri WHERE { ?uri dbo:team ?team . ?league dbo:league res:Premier_League . ?league dbo:team ?team . ?uri dbo:birthDate ?date } ORDER BY DESC(?date) LIMIT 1

# ID = 95,

# Question = Who is the youngest player in the Premier League?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  ?uri dbo:team ?team.

  ?league dbo:team ?team.

  ?league dbo:league dbr:Premier_League.

  ?uri dbo:birthDate ?birthDate.

}

ORDER BY DESC(?birthDate)

LIMIT 1

 

 

 

OK

96

Which professional surfers were born on the Philippines?

PREFIX dbr: <http://dbpedia.org/resource/> PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX res: <http://dbpedia.org/resource/> SELECT DISTINCT ?uri WHERE { ?uri dbo:occupation dbr:Surfer ; dbo:birthPlace res:Philippines }

# ID = 96,

# Question = Which professional surfers were born on the Philippines?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  ?uri dbo:occupation dbr:Surfer.

  ?uri dbo:birthPlace dbr:Philippines.

}

 

 

OK

 

No results

 

97

Give me the official websites of actors of the television show Charmed.

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX foaf: <http://xmlns.com/foaf/0.1/> PREFIX onto: <http://dbpedia.org/ontology/> SELECT DISTINCT ?uri WHERE { <http://dbpedia.org/resource/Charmed> onto:starring ?actors . ?actors foaf:homepage ?uri }

# ID = 97,

# Question = Give me the official websites of actors of the television show Charmed.

PREFIX foaf: <http://xmlns.com/foaf/0.1/>

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?homepage WHERE{

  dbr:Charmed dbo:starring ?actors.

  ?actors foaf:homepage ?homepage.

}

 

 

OK

 

No results

 

98

Who killed Caesar?

PREFIX dct: <http://purl.org/dc/terms/> PREFIX dbc: <http://dbpedia.org/resource/Category:> SELECT DISTINCT ?uri WHERE { ?uri dct:subject dbc:Assassins_of_Julius_Caesar }

# ID = 98,

# Question = Who killed Caesar?

PREFIX dct: <http://purl.org/dc/terms/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  ?uri dct:subject dbr:Category:Assassins_of_Julius_Caesar.

}

 

 

OK

99

What is the time zone of Salt Lake City?

PREFIX res: <http://dbpedia.org/resource/> PREFIX dbp: <http://dbpedia.org/property/> SELECT DISTINCT ?uri WHERE { res:Salt_Lake_City <http://dbpedia.org/ontology/timeZone> ?uri }

# ID = 99,

# Question = What is the time zone of Salt Lake City?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?timeZone WHERE{

  dbr:Salt_Lake_City dbo:timeZone ?timeZone.

}

 

OK

101

How many companies were founded by the founder of Facebook?

SELECT (COUNT(DISTINCT ?x) AS ?c) WHERE { <http://dbpedia.org/resource/Facebook> <http://dbpedia.org/ontology/foundedBy> ?uri . ?x <http://dbpedia.org/ontology/foundedBy> ?uri }

# ID = 101,

# Question = How many companies were founded by the founder of Facebook?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT (COUNT(DISTINCT ?x) AS ?c) WHERE{

  ?x dbo:foundedBy ?uri.

  dbr:Facebook dbo:foundedBy ?uri.

}

 

OK

102

When did Dracula's creator die?

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> SELECT DISTINCT (xsd:date(?date) as ?d) WHERE { <http://dbpedia.org/resource/Count_Dracula> <http://dbpedia.org/ontology/creator> ?x . ?x <http://dbpedia.org/ontology/deathDate> ?date. }

# ID = 102,

# Question = When did Dracula's creator die?

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?d WHERE{

  dbr:Count_Dracula dbo:creator ?x.

  dbr:Count_Dracula dbo:date ?date.

  ?x dbo:deathDate ?date.

  BIND(xsd:date(?date) AS ?d)

}

 

OK

 

103

Where does Piccadilly start?

SELECT DISTINCT ?uri WHERE { ?uri <http://dbpedia.org/ontology/routeStart> <http://dbpedia.org/resource/Piccadilly> }

# ID = 103,

# Question = Where does Piccadilly start?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  ?uri dbo:routeStart dbr:Piccadilly.

}

 

OK

104

Who is the daughter of Robert Kennedy married to?

SELECT DISTINCT ?uri WHERE { <http://dbpedia.org/resource/Robert_F._Kennedy> <http://dbpedia.org/ontology/child> ?child . ?child <http://dbpedia.org/ontology/spouse> ?uri }

# ID = 104,

# Question = Who is the daughter of Robert Kennedy married to?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?spouse WHERE{

  dbr:Robert_F._Kennedy dbo:child ?child.

  ?child dbo:spouse ?spouse.

}

 

OK

105

Which countries have more than ten volcanoes?

SELECT DISTINCT ?uri WHERE { ?x a <http://dbpedia.org/ontology/Volcano> ; <http://dbpedia.org/ontology/locatedInArea> ?uri . ?uri a <http://dbpedia.org/ontology/Country> } GROUP BY ?uri HAVING ( COUNT(?x) > 10 )

# ID = 105,

# Question = Which countries have more than ten volcanoes?

#

# Manually edited

PREFIX dbo: <http://dbpedia.org/ontology/>

SELECT ?uri WHERE{

  {SELECT ?uri (COUNT(?x) AS ?c) WHERE{

    ?x a dbo:Volcano.

    ?uri a dbo:Country.

    ?x dbo:locatedInArea ?uri.}

    GROUP BY ?uri

  }

  FILTER(?c >= 10)

}

 

Manually edited

 

TO DO:

HAVING

107

Who was the father of Queen Elizabeth II?

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX res: <http://dbpedia.org/resource/> SELECT DISTINCT * WHERE { res:Elizabeth_II dbo:parent ?uri . ?uri <http://xmlns.com/foaf/0.1/gender> "male"@en }

# ID = 107,

# Question = Who was the father of Queen Elizabeth II?

PREFIX foaf: <http://xmlns.com/foaf/0.1/>

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  dbr:Elizabeth_II dbo:parent ?uri.

  ?uri foaf:gender "male"@en .

}

 

OK

108

When did Paraguay proclaim its independence?

SELECT DISTINCT ?date WHERE { <http://dbpedia.org/resource/Paraguay> <http://dbpedia.org/ontology/foundingDate> ?date }

# ID = 108,

# Question = When did Paraguay proclaim its independence?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?foundingDate WHERE{

  dbr:Paraguay dbo:foundingDate ?foundingDate.

}

 

OK

 

No results

 

110

Which movies did Kurosawa direct?

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX res: <http://dbpedia.org/resource/> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> SELECT ?uri WHERE { ?uri rdf:type dbo:Film ; dbo:director res:Akira_Kurosawa }

# ID = 110,

# Question = Which movies did Kurosawa direct?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT ?uri WHERE{

  ?uri a dbo:Film.

  ?uri dbo:director dbr:Akira_Kurosawa.

}

 

OK

111

How many awards has Bertrand Russell?

PREFIX dbr: <http://dbpedia.org/resource/> PREFIX dbp: <http://dbpedia.org/property/> SELECT (COUNT(?Awards) AS ?Counter) WHERE { dbr:Bertrand_Russell dbp:awards ?Awards }

# ID = 111,

# Question = How many awards has Bertrand Russell?

PREFIX dbp: <http://dbpedia.org/property/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT (COUNT(?Awards) AS ?Counter) WHERE{

  dbr:Bertrand_Russell dbp:awards ?Awards.

}

 

OK

113

Which German cities have more than 250000 inhabitants?

SELECT DISTINCT ?uri WHERE { { ?uri a <http://dbpedia.org/ontology/City> } UNION { ?uri a <http://dbpedia.org/ontology/Town> } ?uri <http://dbpedia.org/ontology/country> <http://dbpedia.org/resource/Germany> ; <http://dbpedia.org/ontology/populationTotal> ?population FILTER ( ?population > 250000 ) }

# ID = 113,

# Question = Which German cities have more than 250000 inhabitants?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  ?uri dbo:country dbr:Germany.

  {

    ?uri a dbo:City.

  }

  UNION

  {

    ?uri a dbo:Town.

  }

  ?uri dbo:populationTotal ?populationTotal.

  FILTER(?populationTotal > 250000)

}

 

 

OK

114

How big is the earth's diameter?

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX res: <http://dbpedia.org/resource/> SELECT DISTINCT (( xsd:double(?radius) * 2 ) AS ?diameter) WHERE { res:Earth dbo:meanRadius ?radius }

# ID = 114,

# Question = How big is the earth's diameter?

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?diameter WHERE{

  dbr:Earth dbo:meanRadius ?meanRadius_1.

  BIND(xsd:double(?meanRadius_1) AS ?expr_0)

  BIND(?expr_0 * 2 AS ?diameter)

}

 

OK

115

How many rivers and lakes are in South Carolina?

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX dct: <http://purl.org/dc/terms/> PREFIX dbc: <http://dbpedia.org/resource/Category:> PREFIX dbr: <http://dbpedia.org/resource/> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> SELECT (COUNT(DISTINCT ?uri) AS ?count) WHERE { { ?uri dbo:location dbr:South_Carolina ; rdf:type dbo:Lake } UNION { ?uri dct:subject dbc:Rivers_and_streams_of_South_Carolina } }

# ID = 115,

# Question = How many rivers and lakes are in South Carolina?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dct: <http://purl.org/dc/terms/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT (COUNT(DISTINCT ?uri) AS ?count) WHERE{

{

  ?uri a dbo:Lake.

  ?uri dbo:location dbr:South_Carolina.

}

UNION

{

?uri dct:subject dbr:Category:Rivers_and_streams_of_South_Carolina.

}}

 

 

 

 

OK

116

Who was called Rodzilla?

SELECT DISTINCT ?uri WHERE { ?uri <http://xmlns.com/foaf/0.1/nick> "Rodzilla"@en }

# ID = 116,

# Question = Who was called Rodzilla?

PREFIX foaf: <http://xmlns.com/foaf/0.1/>

SELECT DISTINCT ?uri WHERE{

  ?uri foaf:nick "Rodzilla"@en .

}

 

OK

 

No results

 

117

Is Pamela Anderson a vegan?

PREFIX dbr: <http://dbpedia.org/resource/> ASK WHERE { dbr:Pamela_Anderson a <http://dbpedia.org/class/yago/WikicatAmericanVegans> }

# ID = 117,

# Question = Is Pamela Anderson a vegan?

PREFIX yago: <http://dbpedia.org/class/yago/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT ?WikicatAmericanVegans WHERE{

  ?WikicatAmericanVegans a yago:WikicatAmericanVegans.

  FILTER(?WikicatAmericanVegans = dbr:Pamela_Anderson)

}

LIMIT 1

 

 

OK

 

ASK

119

Which instruments does Cat Stevens play?

SELECT DISTINCT ?uri WHERE { <http://dbpedia.org/resource/Cat_Stevens> <http://dbpedia.org/ontology/instrument> ?uri }

# ID = 119,

# Question = Which instruments does Cat Stevens play?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?instrument WHERE{

  dbr:Cat_Stevens dbo:instrument ?instrument.

}

 

OK

 

No results

 

120

Who is the daughter of Bill Clinton married to?

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX dbp: <http://dbpedia.org/property/> PREFIX dbr: <http://dbpedia.org/resource/> SELECT DISTINCT ?uri WHERE { dbr:Bill_Clinton dbo:child ?child . ?child dbo:spouse ?uri . ?uri rdfs:label ?string }

# ID = 120,

# Question = Who is the daughter of Bill Clinton married to?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  dbr:Bill_Clinton dbo:child ?child.

  ?child dbo:spouse ?uri.

  ?uri rdfs:label ?label.

}

 

 

OK

122

Who was the wife of President Lincoln?

PREFIX dbr: <http://dbpedia.org/resource/> PREFIX onto: <http://dbpedia.org/ontology/> SELECT ?uri WHERE { dbr:Abraham_Lincoln onto:spouse ?uri }

# ID = 122,

# Question = Who was the wife of President Lincoln?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT ?spouse WHERE{

  dbr:Abraham_Lincoln dbo:spouse ?spouse.

}

 

OK

123

Give me all animals that are extinct.

SELECT DISTINCT ?uri WHERE { ?uri a <http://dbpedia.org/ontology/Animal> ; <http://dbpedia.org/ontology/conservationStatus> "EX" }

# ID = 123,

# Question = Give me all animals that are extinct.

PREFIX dbo: <http://dbpedia.org/ontology/>

SELECT DISTINCT ?uri WHERE{

  ?uri a dbo:Animal.

  ?uri dbo:conservationStatus "EX" .

}

 

 

OK

124

When was Carlo Giuliani shot?

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX dbo: <http://dbpedia.org/ontology/>

 PREFIX res: <http://dbpedia.org/resource/> PREFIX dbp: <http://dbpedia.org/property/> SELECT DISTINCT (xsd:date(?date) as ?d) WHERE { res:Death_of_Carlo_Giuliani dbo:deathDate ?date }

# ID = 124,

# Question = When was Carlo Giuliani shot?

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?d WHERE{

  dbr:Death_of_Carlo_Giuliani dbo:deathDate ?deathDate.

  BIND(xsd:date(?deathDate) AS ?d)

}

 

OK

125

How many years was the Ford Model T manufactured?

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX res: <http://dbpedia.org/resource/> SELECT ?years WHERE { res:Ford_Model_T dbo:productionEndYear ?end ; dbo:productionStartYear ?start. BIND ( ( year(xsd:date(?end)) - year(xsd:date(?start)) ) AS ?years) }

# ID = 125,

# Question = How many years was the Ford Model T manufactured?

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT ?years WHERE{

  dbr:Ford_Model_T dbo:productionEndYear ?productionEndYear_1.

  dbr:Ford_Model_T dbo:productionStartYear ?productionStartYear_1.

  BIND(YEAR(xsd:dateTime(?productionEndYear_1))-YEAR(xsd:dateTime(?productionStartYear_1)) AS ?years)

}

 

OK

126

Sean Parnell was the governor of which U.S. state?

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX res: <http://dbpedia.org/resource/> SELECT DISTINCT ?uri WHERE { res:Sean_Parnell dbo:region ?uri }

# ID = 126,

# Question = Sean Parnell was the governor of which U.S. state?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?region WHERE{

  dbr:Sean_Parnell dbo:region ?region.

}

 

OK

 

No results

 

128

Who is the author of WikiLeaks?

PREFIX res: <http://dbpedia.org/resource/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX onto: <http://dbpedia.org/ontology/> SELECT ?uri WHERE { res:WikiLeaks onto:author ?uri }

# ID = 128,

# Question = Who is the author of WikiLeaks?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT ?author WHERE{

  dbr:WikiLeaks dbo:author ?author.

}

 

OK

129

Who does the voice of Bart Simpson?

SELECT DISTINCT ?uri WHERE { <http://dbpedia.org/resource/Bart_Simpson> <http://dbpedia.org/property/voiceactor> ?uri }

# ID = 129,

# Question = Who does the voice of Bart Simpson?

PREFIX dbp: <http://dbpedia.org/property/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?voiceactor WHERE{

  dbr:Bart_Simpson dbp:voiceactor ?voiceactor.

}

 

OK

 

No results

 

131

What languages are spoken in Pakistan?

SELECT DISTINCT ?uri WHERE { <http://dbpedia.org/resource/Pakistan> <http://dbpedia.org/ontology/language> ?uri }

# ID = 131,

# Question = What languages are spoken in Pakistan?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?language WHERE{

  dbr:Pakistan dbo:language ?language.

}

 

OK

 

 

132

What is Elon Musk famous for?

SELECT DISTINCT ?uri WHERE { <http://dbpedia.org/resource/Elon_Musk> <http://dbpedia.org/ontology/knownFor> ?uri }

# ID = 132,

# Question = What is Elon Musk famous for?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?knownFor WHERE{

  dbr:Elon_Musk dbo:knownFor ?knownFor.

}

 

OK

 

No results

 

133

What are the names of the Teenage Mutant Ninja Turtles?

PREFIX foaf:<http://xmlns.com/foaf/0.1/> SELECT DISTINCT ?s WHERE { <http://dbpedia.org/resource/Teenage_Mutant_Ninja_Turtles> <http://dbpedia.org/property/members> ?x . ?x foaf:givenName ?s }

# ID = 133,

# Question = What are the names of the Teenage Mutant Ninja Turtles?

PREFIX foaf: <http://xmlns.com/foaf/0.1/>

PREFIX dbp: <http://dbpedia.org/property/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?givenName WHERE{

  dbr:Teenage_Mutant_Ninja_Turtles dbp:members ?x.

  ?x foaf:givenName ?givenName.

}

 

 

OK

 

No results

 

134

What is Batman's real name?

SELECT DISTINCT ?label WHERE { <http://dbpedia.org/resource/Batman> <http://xmlns.com/foaf/0.1/name> ?label FILTER ( str(?label) != "Batman" ) }

# ID = 134,

# Question = What is Batman's real name?

PREFIX foaf: <http://xmlns.com/foaf/0.1/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?label WHERE{

  dbr:Batman foaf:name ?label.

  FILTER(STR(?label) != "Batman")

}

 

 

OK

135

When did Michael Jackson die?

SELECT DISTINCT ?date WHERE { <http://dbpedia.org/resource/Michael_Jackson> <http://dbpedia.org/ontology/deathDate> ?date }

# ID = 135,

# Question = When did Michael Jackson die?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?deathDate WHERE{

  dbr:Michael_Jackson dbo:deathDate ?deathDate.

}

 

OK

136

How many moons does Mars have?

SELECT DISTINCT ?n WHERE { <http://dbpedia.org/resource/Mars> <http://dbpedia.org/property/satellites> ?n }

# ID = 136,

# Question = How many moons does Mars have?

PREFIX dbp: <http://dbpedia.org/property/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?satellites WHERE{

  dbr:Mars dbp:satellites ?satellites.

}

 

OK

137

Give me all Dutch parties.

SELECT DISTINCT ?uri WHERE { ?uri a <http://dbpedia.org/ontology/PoliticalParty> ; <http://dbpedia.org/ontology/country> <http://dbpedia.org/resource/Netherlands> }

# ID = 137,

# Question = Give me all Dutch parties.

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  ?uri a dbo:PoliticalParty.

  ?uri dbo:country dbr:Netherlands.

}

 

 

OK

 

 

138

Give me the capitals of all countries in Africa.

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX dbc: <http://dbpedia.org/resource/Category:> PREFIX dct: <http://purl.org/dc/terms/> SELECT DISTINCT ?uri WHERE { ?country dct:subject dbc:Countries_in_Africa ; dbo:capital ?uri }

# ID = 138,

# Question = Give me the capitals of all countries in Africa.

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dct: <http://purl.org/dc/terms/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?capital WHERE{

  ?country dct:subject dbr:Category:Countries_in_Africa.

  ?country dbo:capital ?capital.

}

 

 

OK

139

Which professional surfers were born in Australia?

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX res: <http://dbpedia.org/resource/> PREFIX dbr: <http://dbpedia.org/resource/> SELECT DISTINCT ?uri WHERE {

{ ?uri dbo:occupation res:Surfer ;   

       dbo:birthPlace res:Australia }

UNION

{ ?uri dbo:occupation res:Surfer ;

       dbo:birthPlace ?place .

?place dbo:country res:Australia } }

# ID = 139,

# Question = Which professional surfers were born in Australia?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT ?uri WHERE{

{

  ?uri dbo:occupation dbr:Surfer.

  ?uri dbo:birthPlace dbr:Australia.

}

UNION

{

?uri dbo:occupation dbr:Surfer.

?uri dbo:birthPlace ?place.

?place dbo:country dbr:Australia.

}}

 

 

 

OK

 

No results

 

140

How many scientists graduated from an Ivy League university?

SELECT (COUNT(DISTINCT ?uri) AS ?c) WHERE { ?uri a <http://dbpedia.org/ontology/Scientist> ; <http://dbpedia.org/ontology/almaMater> ?university . ?university <http://dbpedia.org/ontology/affiliation> <http://dbpedia.org/resource/Ivy_League> ; a <http://dbpedia.org/ontology/University> }

# ID = 140,

# Question = How many scientists graduated from an Ivy League university?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT (COUNT(DISTINCT ?uri) AS ?c) WHERE{

  ?uri a dbo:Scientist.

  ?uri dbo:almaMater ?university.

  ?university a dbo:University.

  ?university dbo:affiliation dbr:Ivy_League.

}

 

 

OK

141

Which languages are spoken in Estonia?

SELECT DISTINCT ?uri WHERE { ?uri <http://dbpedia.org/ontology/spokenIn> <http://dbpedia.org/resource/Estonia> }

# ID = 141,

# Question = Which languages are spoken in Estonia?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  ?uri dbo:spokenIn dbr:Estonia.

}

 

OK

143

What is the area code of Berlin?

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX res: <http://dbpedia.org/resource/> SELECT DISTINCT ?string WHERE { res:Berlin dbo:areaCode ?string }

# ID = 143,

# Question = What is the area code of Berlin?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?areaCode WHERE{

  dbr:Berlin dbo:areaCode ?areaCode.

}

 

OK

144

Whom did Lance Bass marry?

PREFIX dbo: <http://dbpedia.org/ontology/> SELECT DISTINCT ?uri WHERE { {<http://dbpedia.org/resource/Lance_Bass> dbo:spouse ?uri} UNION {?uri dbo:spouse <http://dbpedia.org/resource/Lance_Bass>} }

# ID = 144,

# Question = Whom did Lance Bass marry?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT ?uri WHERE{

{

  dbr:Lance_Bass dbo:spouse ?uri.

}

UNION

{

?uri dbo:spouse dbr:Lance_Bass.

}}

 

 

 

OK

 

No results

 

145

Who owns Aldi?

PREFIX res: <http://dbpedia.org/resource/> PREFIX dbp: <http://dbpedia.org/property/> SELECT DISTINCT ?uri WHERE { res:Aldi dbp:founders ?uri }

# ID = 145,

# Question = Who owns Aldi?

PREFIX dbp: <http://dbpedia.org/property/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?founders WHERE{

  dbr:Aldi dbp:founders ?founders.

}

 

OK

148

What is the largest state in the United States?

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX dct: <http://purl.org/dc/terms/> PREFIX dbc: <http://dbpedia.org/resource/Category:> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> SELECT ?uri WHERE { ?uri dct:subject dbc:States_of_the_United_States ; rdf:type dbo:AdministrativeRegion ; dbo:areaTotal ?area } ORDER BY DESC(?area) OFFSET 0 LIMIT 1

# ID = 148,

# Question = What is the largest state in the United States?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dct: <http://purl.org/dc/terms/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT ?uri WHERE{

  ?uri a dbo:AdministrativeRegion.

  ?uri dct:subject dbr:Category:States_of_the_United_States.

  ?uri dbo:areaTotal ?areaTotal.

}

ORDER BY DESC(?areaTotal)

LIMIT 1

 

 

 

OK

149

Which U.S. state has the highest population density?

SELECT ?uri WHERE {

?uri <http://dbpedia.org/ontology/country> <http://dbpedia.org/resource/United_States> . ?uri <http://dbpedia.org/ontology/capital> ?capital .

?uri <http://dbpedia.org/property/densityrank> ?density .

OPTIONAL {?uri <http://www.w3.org/2000/01/rdf-schema#label> ?string. FILTER (lang(?string) = 'en') } } ORDER BY ASC(?density) LIMIT 1

# ID = 149,

# Question = Which U.S. state has the highest population density?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT ?uri WHERE{

  ?uri dbo:country dbr:United_States.

  ?uri dbo:capital ?capital.

  OPTIONAL{?uri rdfs:label ?string. FILTER(LANG(?string) = 'en')}

  ?uri dbp:densityrank ?densityrank.

}

ORDER BY ?densityrank

LIMIT 1

 

 

 

OK

 

No results

 

150

In which city was the president of Montenegro born?

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX dbr: <http://dbpedia.org/resource/> SELECT DISTINCT ?uri WHERE { ?x <http://dbpedia.org/property/title> dbr:President_of_Montenegro ; dbo:birthPlace ?uri . ?uri dbo:type dbr:Capital_city }

# ID = 150,

# Question = In which city was the president of Montenegro born?

PREFIX dbp: <http://dbpedia.org/property/>

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  ?x dbp:title dbr:President_of_Montenegro.

  ?x dbo:birthPlace ?uri.

  ?uri dbo:type dbr:Capital_city.

}

 

 

OK

151

Give me all B-sides of the Ramones.

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX res: <http://dbpedia.org/resource/> PREFIX dbp: <http://dbpedia.org/property/> SELECT DISTINCT ?string WHERE { ?x dbo:musicalArtist res:Ramones ; dbo:bSide ?string }

# ID = 151,

# Question = Give me all B-sides of the Ramones.

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?bSide WHERE{

  ?x dbo:musicalArtist dbr:Ramones.

  ?x dbo:bSide ?bSide.

}

 

 

OK

 

No results

 

152

Which beer brewing companies are located in North-Rhine Westphalia?

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX dct: <http://purl.org/dc/terms/> PREFIX dbc: <http://dbpedia.org/resource/Category:> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> SELECT ?company WHERE { ?company dct:subject dbc:Companies_based_in_North_Rhine-Westphalia ; rdf:type dbo:Brewery }

# ID = 152,

# Question = Which beer brewing companies are located in North-Rhine Westphalia?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dct: <http://purl.org/dc/terms/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT ?company WHERE{

  ?company a dbo:Brewery.

  ?company dct:subject dbr:Category:Companies_based_in_North_Rhine-Westphalia.

}

 

 

OK

154

Which books were written by Danielle Steel?

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX foaf: <http://xmlns.com/foaf/0.1/> PREFIX onto: <http://dbpedia.org/ontology/> SELECT ?uri WHERE { ?uri rdf:type onto:Book ; onto:author <http://dbpedia.org/resource/Danielle_Steel> }

# ID = 154,

# Question = Which books were written by Danielle Steel?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT ?uri WHERE{

  ?uri a dbo:Book.

  ?uri dbo:author dbr:Danielle_Steel.

}

 

 

OK

155

What is the nick name of Baghdad?

PREFIX dbr: <http://dbpedia.org/resource/> PREFIX foaf: <http://xmlns.com/foaf/0.1/> SELECT ?nm WHERE { dbr:Baghdad foaf:nick ?nm }

# ID = 155,

# Question = What is the nick name of Baghdad?

PREFIX foaf: <http://xmlns.com/foaf/0.1/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT ?nick WHERE{

  dbr:Baghdad foaf:nick ?nick.

}

 

OK

156

Where is Fort Knox located?

SELECT DISTINCT ?uri WHERE { <http://dbpedia.org/resource/Fort_Knox> <http://dbpedia.org/ontology/location> ?uri. ?uri a <http://dbpedia.org/ontology/Place>. }

# ID = 156,

# Question = Where is Fort Knox located?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  dbr:Fort_Knox dbo:location ?uri.

  ?uri a dbo:Place.

}

 

 

OK

157

Give me English actors starring in Lovesick.

PREFIX dbo: <http://dbpedia.org/ontology/> SELECT DISTINCT ?uri WHERE { <http://dbpedia.org/resource/Lovesick_(1983_film)> dbo:starring ?uri . ?uri dbo:birthPlace ?city . ?city dbo:country <http://dbpedia.org/resource/United_Kingdom> }

# ID = 157,

# Question = Give me English actors starring in Lovesick.

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  <http://dbpedia.org/resource/Lovesick_(1983_film)> dbo:starring ?uri.

  ?uri dbo:birthPlace ?city.

  ?city dbo:country dbr:United_Kingdom.

}

 

 

OK

158

Give me all writers that won the Nobel Prize in literature.

SELECT DISTINCT ?uri WHERE { ?uri a <http://dbpedia.org/ontology/Writer> ; <http://dbpedia.org/ontology/award> <http://dbpedia.org/resource/Nobel_Prize_in_Literature> }

# ID = 158,

# Question = Give me all writers that won the Nobel Prize in literature.

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  ?uri a dbo:Writer.

  ?uri dbo:award dbr:Nobel_Prize_in_Literature.

}

 

 

OK

 

 

159

Which countries are connected by the Rhine?

PREFIX dbr: <http://dbpedia.org/resource/> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX dbp: <http://dbpedia.org/property/> PREFIX dbo: <http://dbpedia.org/ontology/> SELECT DISTINCT ?uri WHERE { {<http://dbpedia.org/resource/Rhine> dbo:country ?uri } UNION {dbr:Rhine dbp:country ?uri} }

# ID = 159,

# Question = Which countries are connected by the Rhine?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbp: <http://dbpedia.org/property/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  dbr:Rhine dbo:country|dbp:country ?uri.

}

 

 

 

 

OK

 

No results

 

160

Who wrote Harry Potter?

SELECT DISTINCT ?uri WHERE { <http://dbpedia.org/resource/Harry_Potter> <http://dbpedia.org/property/author> ?uri }

# ID = 160,

# Question = Who wrote Harry Potter?

PREFIX dbp: <http://dbpedia.org/property/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?author WHERE{

  dbr:Harry_Potter dbp:author ?author.

}

 

OK

162

How deep is Lake Chiemsee?

SELECT DISTINCT ?n WHERE { <http://dbpedia.org/resource/Chiemsee> <http://dbpedia.org/ontology/maximumDepth> ?n }

# ID = 162,

# Question = How deep is Lake Chiemsee?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?maximumDepth WHERE{

  dbr:Chiemsee dbo:maximumDepth ?maximumDepth.

}

 

 

OK

163

Give me all chemical elements.

PREFIX dct: <http://purl.org/dc/terms/> PREFIX dbc: <http://dbpedia.org/resource/Category:> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX owl: <http://www.w3.org/2002/07/owl#> SELECT DISTINCT ?uri WHERE { ?uri rdf:type owl:Thing ; dct:subject dbc:Chemical_elements }

# ID = 163,

# Question = Give me all chemical elements.

PREFIX owl: <http://www.w3.org/2002/07/owl#>

PREFIX dct: <http://purl.org/dc/terms/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  ?uri a owl:Thing.

  ?uri dct:subject dbr:Category:Chemical_elements.

}

 

 

OK

164

Who was on the Apollo 11 mission?

SELECT DISTINCT ?uri WHERE { <http://dbpedia.org/resource/Apollo_11> <http://dbpedia.org/property/crewMembers> ?uri }

# ID = 164,

# Question = Who was on the Apollo 11 mission?

PREFIX dbp: <http://dbpedia.org/property/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?crewMembers WHERE{

  dbr:Apollo_11 dbp:crewMembers ?crewMembers.

}

 

 

OK

165

What is the name of the university where Obama's wife studied?

SELECT DISTINCT ?s WHERE { <http://dbpedia.org/resource/Barack_Obama> <http://dbpedia.org/ontology/spouse> ?x . ?x <http://dbpedia.org/ontology/almaMater> ?s }

# ID = 165,

# Question = What is the name of the university where Obama's wife studied?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?almaMater WHERE{

  dbr:Barack_Obama dbo:spouse ?x.

  ?x dbo:almaMater ?almaMater.

}

 

 

OK

 

No results

 

166

Which computer scientist won an oscar?

SELECT DISTINCT ?uri WHERE { ?uri <http://dbpedia.org/ontology/field> <http://dbpedia.org/resource/Computer_science> ; <http://dbpedia.org/ontology/award> <http://dbpedia.org/resource/Academy_Award> }

# ID = 166,

# Question = Which computer scientist won an oscar?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  ?uri dbo:field dbr:Computer_science.

  ?uri dbo:award dbr:Academy_Award.

}

 

 

OK

 

No results

 

167

Which subsidiary of TUI Travel serves both Glasgow and Dublin?

SELECT DISTINCT ?uri WHERE { <http://dbpedia.org/resource/TUI_Travel> <http://dbpedia.org/ontology/subsidiary> ?uri .

?uri <http://dbpedia.org/ontology/targetAirport> <http://dbpedia.org/resource/Glasgow_International_Airport> ; <http://dbpedia.org/ontology/targetAirport> <http://dbpedia.org/resource/Dublin_Airport> }

# ID = 167,

# Question = Which subsidiary of TUI Travel serves both Glasgow and Dublin?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  dbr:TUI_Travel dbo:subsidiary ?uri.

  ?uri dbo:targetAirport dbr:Glasgow_International_Airport.

  ?uri dbo:targetAirport dbr:Dublin_Airport.

}

 

 

OK

 

No results

 

168

Which actors play in Big Bang Theory?

SELECT DISTINCT ?uri WHERE { <http://dbpedia.org/resource/The_Big_Bang_Theory> <http://dbpedia.org/ontology/starring> ?uri }

# ID = 168,

# Question = Which actors play in Big Bang Theory?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?starring WHERE{

  dbr:The_Big_Bang_Theory dbo:starring ?starring.

}

 

OK

169

Give me all libraries established before 1400.

SELECT DISTINCT ?uri WHERE { ?uri a <http://dbpedia.org/ontology/Library> ; <http://dbpedia.org/property/established> ?year FILTER ( ?year < 1400 ) }

# ID = 169,

# Question = Give me all libraries established before 1400.

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbp: <http://dbpedia.org/property/>

SELECT DISTINCT ?uri WHERE{

  ?uri a dbo:Library.

  ?uri dbp:established ?established.

  FILTER(?established < 1400)

}

 

 

OK

171

When did the Boston Tea Party take place?

SELECT DISTINCT ?d WHERE { <http://dbpedia.org/resource/Boston_Tea_Party> <http://dbpedia.org/property/date> ?d }

# ID = 171,

# Question = When did the Boston Tea Party take place?

PREFIX dbp: <http://dbpedia.org/property/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?date WHERE{

  dbr:Boston_Tea_Party dbp:date ?date.

}

 

OK

173

When did Finland join the EU?

PREFIX res: <http://dbpedia.org/resource/> PREFIX dbp: <http://dbpedia.org/property/> SELECT DISTINCT ?date WHERE { res:Finland dbp:accessioneudate ?date }

# ID = 173,

# Question = When did Finland join the EU?

PREFIX dbp: <http://dbpedia.org/property/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?accessioneudate WHERE{

  dbr:Finland dbp:accessioneudate ?accessioneudate.

}

 

OK

 

No results

 

174

Who is the novelist of the work a song of ice and fire?

PREFIX dbr: <http://dbpedia.org/resource/> PREFIX dbp: <http://dbpedia.org/property/> SELECT ?Novelist WHERE { dbr:A_Song_of_Ice_and_Fire dbp:author ?Novelist }

# ID = 174,

# Question = Who is the novelist of the work a song of ice and fire?

PREFIX dbp: <http://dbpedia.org/property/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT ?author WHERE{

  dbr:A_Song_of_Ice_and_Fire dbp:author ?author.

}

 

OK

175

When did Muhammad die?

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX res: <http://dbpedia.org/resource/> SELECT DISTINCT (xsd:date(?date) as ?d) WHERE { res:Muhammad dbo:deathDate ?date }

# ID = 175,

# Question = When did Muhammad die?

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?d WHERE{

  dbr:Muhammad dbo:deathDate ?deathDate.

  BIND(xsd:date(?deathDate) AS ?d)

}

 

 

OK

176

Who painted The Storm on the Sea of Galilee?

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX res: <http://dbpedia.org/resource/> PREFIX dbp: <http://dbpedia.org/property/> SELECT DISTINCT ?uri WHERE { res:The_Storm_on_the_Sea_of_Galilee dbo:author ?uri }

# ID = 176,

# Question = Who painted The Storm on the Sea of Galilee?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?author WHERE{

  dbr:The_Storm_on_the_Sea_of_Galilee dbo:author ?author.

}

 

OK

177

Which bridges are of the same type as the Manhattan Bridge?

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX dbr: <http://dbpedia.org/resource/> SELECT DISTINCT ?bridge WHERE { dbr:Manhattan_Bridge dbo:type ?type . ?bridge dbo:type ?type ; rdf:type dbo:Bridge }

# ID = 177,

# Question = Which bridges are of the same type as the Manhattan Bridge?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?bridge WHERE{

  dbr:Manhattan_Bridge dbo:type ?type.

  ?bridge dbo:type ?type.

  ?bridge a dbo:Bridge.

}

 

 

OK

178

How many James Bond movies do exist?

PREFIX dct: <http://purl.org/dc/terms/> SELECT (COUNT(DISTINCT ?uri) AS ?c) WHERE { ?uri dct:subject <http://dbpedia.org/resource/Category:James_Bond_films> }

# ID = 178,

# Question = How many James Bond movies do exist?

PREFIX dct: <http://purl.org/dc/terms/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT (COUNT(DISTINCT ?uri) AS ?c) WHERE{

  ?uri dct:subject dbr:Category:James_Bond_films.

}

 

 

OK

179

What were the names of the three ships by Columbus?

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX dct: <http://purl.org/dc/terms/> PREFIX dbc: <http://dbpedia.org/resource/Category:> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> SELECT ?uri WHERE { ?uri rdf:type dbo:Ship ; dct:subject dbc:Christopher_Columbus ; dct:subject dbc:Exploration_ships }

# ID = 179,

# Question = What were the names of the three ships by Columbus?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dct: <http://purl.org/dc/terms/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT ?uri WHERE{

  ?uri a dbo:Ship.

  ?uri dct:subject dbr:Category:Christopher_Columbus.

  ?uri dct:subject dbr:Category:Exploration_ships.

}

 

 

OK

181

Through which countries does the Yenisei river flow?

PREFIX res: <http://dbpedia.org/resource/> PREFIX dbp: <http://dbpedia.org/property/> SELECT DISTINCT ?uri WHERE { res:Yenisei_River <http://dbpedia.org/ontology/country> ?uri }

# ID = 181,

# Question = Through which countries does the Yenisei river flow?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?country WHERE{

  dbr:Yenisei_River dbo:country ?country.

}

 

OK

 

No results

 

182

Which animals are critically endangered?

SELECT DISTINCT ?uri WHERE { ?uri a <http://dbpedia.org/ontology/Animal> ; <http://dbpedia.org/ontology/conservationStatus> "CR" }

# ID = 182,

# Question = Which animals are critically endangered?

PREFIX dbo: <http://dbpedia.org/ontology/>

SELECT DISTINCT ?uri WHERE{

  ?uri a dbo:Animal.

  ?uri dbo:conservationStatus "CR" .

}

 

 

OK

183

Who was Tom Hanks married to?

PREFIX dbr: <http://dbpedia.org/resource/> PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> SELECT DISTINCT ?uri WHERE { dbr:Tom_Hanks dbo:spouse ?uri }

# ID = 183,

# Question = Who was Tom Hanks married to?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?spouse WHERE{

  dbr:Tom_Hanks dbo:spouse ?spouse.

}

 

OK

187

Who is the husband of Amanda Palmer?

SELECT DISTINCT ?uri WHERE { ?uri <http://dbpedia.org/ontology/spouse> <http://dbpedia.org/resource/Amanda_Palmer> }

# ID = 187,

# Question = Who is the husband of Amanda Palmer?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  ?uri dbo:spouse dbr:Amanda_Palmer.

}

 

OK

 

No results

 

188

Give me the homepage of Forbes.

PREFIX res: <http://dbpedia.org/resource/> PREFIX foaf: <http://xmlns.com/foaf/0.1/> SELECT DISTINCT ?string WHERE { res:Forbes foaf:homepage ?string }

# ID = 188,

# Question = Give me the homepage of Forbes.

PREFIX foaf: <http://xmlns.com/foaf/0.1/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?homepage WHERE{

  dbr:Forbes foaf:homepage ?homepage.

}

 

OK

 

No results

 

189

In which studio did the Beatles record their first album?

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX dbp: <http://dbpedia.org/property/> PREFIX dbr: <http://dbpedia.org/resource/> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX db: <http://dbpedia.org/> SELECT ?studio WHERE { ?album dbo:artist dbr:The_Beatles ; rdf:type dbo:Album ; dbo:releaseDate ?date ; dbp:studio ?studio } ORDER BY ASC(?date) LIMIT 1

# ID = 189,

# Question = In which studio did the Beatles record their first album?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbp: <http://dbpedia.org/property/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT ?studio WHERE{

  ?album a dbo:Album.

  ?album dbo:artist dbr:The_Beatles.

  ?album dbp:studio ?studio.

  ?album dbo:releaseDate ?releaseDate.

}

ORDER BY ?releaseDate

LIMIT 1

 

 

OK

190

Who are the parents of the wife of Juan Carlos I?

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX res: <http://dbpedia.org/resource/> SELECT DISTINCT ?uri WHERE { res:Juan_Carlos_I_of_Spain dbo:spouse ?x . ?x dbo:parent ?uri }

# ID = 190,

# Question = Who are the parents of the wife of Juan Carlos I?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?parent WHERE{

  dbr:Juan_Carlos_I_of_Spain dbo:spouse ?x.

  ?x dbo:parent ?parent.

}

 

 

OK

 

No results

 

192

Which museum exhibits The Scream by Munch?

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX res: <http://dbpedia.org/resource/> SELECT DISTINCT ?uri WHERE { res:The_Scream dbo:museum ?uri }

# ID = 192,

# Question = Which museum exhibits The Scream by Munch?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?museum WHERE{

  dbr:The_Scream dbo:museum ?museum.

}

 

OK

194

Which U.S. state has the abbreviation MN?

PREFIX yago: <http://dbpedia.org/class/yago/> SELECT DISTINCT ?uri WHERE { ?uri a yago:WikicatStatesOfTheUnitedStates ; <http://dbpedia.org/property/postalabbreviation> "MN"^^<http://www.w3.org/1999/02/22-rdf-syntax-ns#langString> }

# ID = 194,

# Question = Which U.S. state has the abbreviation MN?

PREFIX yago: <http://dbpedia.org/class/yago/>

PREFIX dbp: <http://dbpedia.org/property/>

SELECT DISTINCT ?uri WHERE{

  ?uri a yago:WikicatStatesOfTheUnitedStates.

  ?uri dbp:postalabbreviation "MN"^^rdf:langString .

}

 

OK

 

No results

 

196

Which classes does the Millepede belong to?

PREFIX res: <http://dbpedia.org/resource/> PREFIX dbp: <http://dbpedia.org/property/> SELECT DISTINCT ?String WHERE { res:Millipede dbp:taxon ?String }

# ID = 196,

# Question = Which classes does the Millepede belong to?

PREFIX dbp: <http://dbpedia.org/property/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?taxon WHERE{

  dbr:Millipede dbp:taxon ?taxon.

}

 

OK

197

Which U.S. state has been admitted latest?

PREFIX dbc: <http://dbpedia.org/resource/Category:> PREFIX dct: <http://purl.org/dc/terms/> SELECT DISTINCT ?uri WHERE { ?uri dct:subject dbc:States_of_the_United_States ; <http://dbpedia.org/property/admittancedate> ?x } ORDER BY DESC(?x) LIMIT 1

# ID = 197,

# Question = Which U.S. state has been admitted latest?

PREFIX dct: <http://purl.org/dc/terms/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  ?uri dct:subject dbr:Category:States_of_the_United_States.

  ?uri dbp:admittancedate ?admittancedate.

}

ORDER BY DESC(?admittancedate)

LIMIT 1

 

 

 

OK

198

Who was influenced by Socrates?

SELECT DISTINCT ?uri WHERE { ?uri <http://dbpedia.org/ontology/influencedBy> <http://dbpedia.org/resource/Socrates> }

# ID = 198,

# Question = Who was influenced by Socrates?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  ?uri dbo:influencedBy dbr:Socrates.

}

 

OK

199

Give me all Argentine films.

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX yago: <http://dbpedia.org/class/yago/> PREFIX res: <http://dbpedia.org/resource/> PREFIX dbp: <http://dbpedia.org/property/> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> SELECT DISTINCT ?uri WHERE {

  { ?uri rdf:type yago:ArgentineFilms}

  UNION

  { ?uri rdf:type dbo:Film

      { ?uri dbo:country res:Argentina }

                   UNION

      { ?uri dbp:country "Argentina"@en }

  }

}

# ID = 199,

# Question = Give me all Argentine films,

#

# Manually edited

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbp: <http://dbpedia.org/property/>

PREFIX yago: <http://dbpedia.org/class/yago/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT ?uri WHERE{

{

  ?uri a dbo:Film.

  {

    ?uri a dbo:Film.

    ?uri dbo:country dbr:Argentina.

  }

  UNION

  {

    ?uri a dbo:Film.

    ?uri dbp:country "Argentina"@en .

  }

}

UNION

{

?uri a yago:ArgentineFilms.

}}

 

Manually edited

 

TO DO:

UNION

201

What is the founding year of the brewery that produces Pilsner Urquell?

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX dbo: <http://dbpedia.org/ontology/> SELECT DISTINCT (xsd:date(?num) as ?n) WHERE { <http://dbpedia.org/resource/Pilsner_Urquell> <http://dbpedia.org/property/brewery> ?uri . ?uri dbo:foundingYear ?num }

 

# ID = 201,

# Question = What is the founding year of the brewery that produces Pilsner Urquell?

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbp: <http://dbpedia.org/property/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?n WHERE{

  dbr:Pilsner_Urquell dbp:brewery ?uri.

  ?uri dbo:foundingYear ?num.

  BIND(xsd:date(?num) AS ?n)

}

 

 

OK

 

203

How did Michael Jackson die?

SELECT DISTINCT ?s WHERE { <http://dbpedia.org/resource/Michael_Jackson> <http://dbpedia.org/property/deathCause> ?s }

# ID = 203,

# Question = How did Michael Jackson die?

PREFIX dbp: <http://dbpedia.org/property/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?deathCause WHERE{

  dbr:Michael_Jackson dbp:deathCause ?deathCause.

}

 

 

OK

206

What was the name of the famous battle in 1836 in San Antonio?

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX dbr: <http://dbpedia.org/resource/> SELECT ?uri WHERE { ?uri a dbo:MilitaryConflict ; dbo:place dbr:San_Antonio ; dbo:date ?date FILTER ( ?date > "1835-12-31T00:00:00Z"^^xsd:dateTime ) FILTER ( ?date <= "1836-12-31T00:00:00Z"^^xsd:dateTime ) }

# ID = 206,

# Question = What was the name of the famous battle in 1836 in San Antonio?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT ?uri WHERE{

  ?uri a dbo:MilitaryConflict.

  ?uri dbo:place dbr:San_Antonio.

  ?uri dbo:date ?date.

  FILTER(?date > "1835-12-31T00:00:00Z"^^xsd:dateTime)

  FILTER(?date <= "1836-12-31T00:00:00Z"^^xsd:dateTime)

}

 

 

OK

207

Which daughters of British earls died at the same place they were born at?

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX yago: <http://dbpedia.org/class/yago/> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> SELECT DISTINCT ?uri WHERE { ?uri rdf:type yago:WikicatDaughtersOfBritishEarls ; dbo:birthPlace ?x ; dbo:deathPlace ?y FILTER ( ?x = ?y ) }

# ID = 207,

# Question = Which daughters of British earls died at the same place they were born at?

PREFIX yago: <http://dbpedia.org/class/yago/>

PREFIX dbo: <http://dbpedia.org/ontology/>

SELECT DISTINCT ?uri WHERE{

  ?uri a yago:WikicatDaughtersOfBritishEarls.

  ?uri dbo:deathPlace ?y.

  ?uri dbo:birthPlace ?birthPlace.

  FILTER(?birthPlace = ?y)

}

 

 

OK

209

Give me all taikonauts.

SELECT DISTINCT ?uri WHERE { { ?uri a <http://dbpedia.org/ontology/Astronaut> ; <http://dbpedia.org/ontology/nationality> <http://dbpedia.org/resource/People's_Republic_of_China> } UNION { ?uri a <http://dbpedia.org/ontology/Astronaut> ; <http://dbpedia.org/ontology/nationality> <http://dbpedia.org/resource/China> } }

# ID = 209,

# Question = Give me all taikonauts.

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT ?uri WHERE{

{

  ?uri a dbo:Astronaut.

  ?uri dbo:nationality <http://dbpedia.org/resource/People's_Republic_of_China>.

}

UNION

{

?uri a dbo:Astronaut.

?uri dbo:nationality dbr:China.

}}

 

 

 

OK

210

Which monarchs of the United Kingdom were married to a German?

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX yago: <http://dbpedia.org/class/yago/> PREFIX res: <http://dbpedia.org/resource/> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> SELECT DISTINCT ?uri WHERE { ?uri rdf:type yago:WikicatMonarchsOfTheUnitedKingdom ; dbo:spouse ?spouse . ?spouse dbo:birthPlace res:Germany }

# ID = 210,

# Question = Which monarchs of the United Kingdom were married to a German?

PREFIX yago: <http://dbpedia.org/class/yago/>

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  ?uri a yago:WikicatMonarchsOfTheUnitedKingdom.

  ?uri dbo:spouse ?spouse.

  ?spouse dbo:birthPlace dbr:Germany.

}

 

 

OK

 

No results

 

211

Give me all American presidents of the last 20 years.

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX dbp: <http://dbpedia.org/property/> PREFIX dct: <http://purl.org/dc/terms/> PREFIX dbc: <http://dbpedia.org/resource/Category:> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> SELECT DISTINCT ?uri WHERE {

?uri rdf:type dbo:Person ;

     dct:subject dbc:Presidents_of_the_United_States ; dbo:activeYearsEndDate ?termEnd FILTER ( ( year(now()) - year(?termEnd) ) <= 20 ) }

# ID = 211,

# Question = Give me all American presidents of the last 20 years.

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>

PREFIX dct: <http://purl.org/dc/terms/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  ?uri a dbo:Person.

  ?uri dct:subject dbr:Category:Presidents_of_the_United_States.

  ?uri dbo:activeYearsEndDate ?activeYearsEndDate.

  FILTER(YEAR(xsd:dateTime(NOW()))-YEAR(xsd:dateTime(?activeYearsEndDate)) <= 20)

}

 

OK

 

No results

 

212

Which companies work in the aerospace industry as well as in medicine?

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX dbr: <http://dbpedia.org/resource/> SELECT DISTINCT ?uri WHERE { ?uri a dbo:Company ; dbo:industry dbr:Aerospace ; dbo:industry dbr:Medical }

# ID = 212,

# Question = Which companies work in the aerospace industry as well as in medicine?

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  ?uri a dbo:Company.

  ?uri dbo:industry dbr:Aerospace.

  ?uri dbo:industry dbr:Medical.

}

 

 

OK

 

No results

 

213

Show me all Czech movies.

SELECT DISTINCT ?uri WHERE { ?uri a <http://dbpedia.org/ontology/Film> ; <http://dbpedia.org/ontology/country> <http://dbpedia.org/resource/Czech_Republic> }

# ID = 213,

# Question = Show me all Czech movies.

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  ?uri a dbo:Film.

  ?uri dbo:country dbr:Czech_Republic.

}

 

 

OK

214

Give me all professional skateboarders from Sweden.

PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX dbp: <http://dbpedia.org/property/> PREFIX dbr: <http://dbpedia.org/resource/> SELECT DISTINCT ?uri WHERE {

?uri dbo:occupation dbr:Skateboarder

{ ?uri dbo:birthPlace dbr:Sweden }

UNION

{ ?uri dbo:birthPlace ?place .

?place dbo:country dbr:Sweden } }

# ID = 214,

# Question = Give me all professional skateboarders from Sweden.

PREFIX dbo: <http://dbpedia.org/ontology/>

PREFIX dbr: <http://dbpedia.org/resource/>

SELECT DISTINCT ?uri WHERE{

  ?uri dbo:occupation dbr:Skateboarder.

  ?uri dbo:birthPlace|dbo:birthPlace/dbo:country dbr:Sweden.

}

 

 

OK

 

No results