Sparql Playground

Abtract of all Batman's movies.sparql

#endpoint: http://dbpedia.org/sparql

PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
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 dc: <http://purl.org/dc/elements/1.1/>
PREFIX : <http://dbpedia.org/resource/>
PREFIX dbpedia2: <http://dbpedia.org/property/>
PREFIX dbpedia: <http://dbpedia.org/>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX dbo: <http://dbpedia.org/ontology/>

SELECT ?film ?title ?abstract
WHERE {
  ?film rdf:type dbo:Film .
  ?film rdfs:label ?title .
  ?film dbo:abstract ?abstract
  FILTER (regex (?title, "Batman", "i") && (lang(?title) = lang(?abstract)))
}
ORDER BY lang(?title)

Actors of Resident Evil.sparql

PREFIX dbo: <http://dbpedia.org/ontology/>
PREFIX res: <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 ?actor_name
WHERE {
  ?film rdf:type dbo:Film .
  ?film rdfs:label ?film_name .
  ?film dbo:starring ?actor .
  ?actor rdfs:label ?actor_name .
  filter( regex(?film_name, "Resident Evil" )) .
  filter (lang(?film_name)='en') .
  filter (lang(?actor_name)='en')
} LIMIT 100

American Romance Novels.sparql

PREFIX dbo: <http://dbpedia.org/ontology/>
PREFIX res:  <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 DISTINCT ?uri ?string 
WHERE {
	?uri rdf:type dbo:Book .
  ?uri dct:subject dbc:American_romance_novels .
	OPTIONAL { ?uri rdfs:label ?string . FILTER (lang(?string) = 'en') }
}

Artists from 60s that released movies in 90s.sparql

#endpoint: http://dbpedia.org/sparql

PREFIX dbo: <http://dbpedia.org/ontology/>
PREFIX res: <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 DISTINCT ?uri ?name ?movie ?released ?birthDate
WHERE {
  ?uri rdf:type dbo:Film .
  ?uri rdfs:label ?movie .
  ?uri dbo:starring ?actors .
  ?uri dbp:released ?released .
  ?actors dbo:birthName ?name .
  ?actors dbo:birthDate ?birthDate .
  FILTER (?birthDate >= "1960-01-01"^^xsd:dateTime && ?birthDate <= "1969-12-31"^^xsd:dateTime) .
  FILTER (?released >= "1990-01-01"^^xsd:date && ?released <= "1999-12-31"^^xsd:date) .
  FILTER (LANG(?movie)='en')
} LIMIT 100

Authors of Wikipedia and his residence.sparql

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 ?string ?residence
WHERE {
	res:Wikipedia dbo:author ?uri .
  ?uri dbo:residence ?residence .
  OPTIONAL { ?uri rdfs:label ?string . FILTER (lang(?string) = 'en') }
}

Books with more than 500 pages published in a different county of the author.sparql

PREFIX dbo: <http://dbpedia.org/ontology/>
PREFIX res:  <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 DISTINCT ?bookName ?pages ?nationality_label
WHERE {
	?book rdf:type dbo:Book .
  ?book rdfs:label ?bookName .
  ?book dbp:pages ?pages .
  ?book dbo:author ?author .
  ?author dbo:birthPlace ?nationality .
  ?nationality rdfs:label ?nationality_label .
  ?book dbp:publisher ?publisher .
  ?publisher dbo:country ?publisherCountry .
  ?publisherCountry rdfs:label ?publisherCountry_label .
  FILTER (?pages > 500)
  FILTER (?publisherCountry_label != ?nationality_label)
	FILTER (lang(?bookName) = 'en')
  FILTER (lang(?nationality_label) = 'en')
}

Companies placed in a city less than Fortaleza.sparql

PREFIX dbp: <http://dbpedia.org/property/>
PREFIX dbo: <http://dbpedia.org/ontology/>
PREFIX res: <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 DISTINCT ?companyName ?locationCity ?numEmployees ?fortalAreaTotal ?cityTotalArea
WHERE { 
  ?company rdf:type dbo:Company  .
  ?company rdfs:label ?companyName .
  ?company dbp:numEmployees ?numEmployees .
  ?company dbo:locationCity ?locationCity .
  ?locationCity dbo:areaTotal ?cityTotalArea .
  <http://dbpedia.org/resource/Fortaleza> dbo:areaTotal ?fortalAreaTotal .
  FILTER (?cityTotalArea <= ?fortalAreaTotal)
  FILTER (?numEmployees > 10000) .
  FILTER (lang(?companyName) = 'en') .
} limit 100

London Eye.sparql

PREFIX res: <http://dbpedia.org/resource/>
PREFIX dbp: <http://dbpedia.org/property/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT DISTINCT ?uri ?string 
WHERE {
        res:London_Eye dbp:architect ?uri .
        OPTIONAL { ?uri rdfs:label ?string. FILTER (lang(?string) = 'en') }
}

Products developed by the owner of World of Warcraft.sparql

PREFIX dbo: <http://dbpedia.org/ontology/>
PREFIX res: <http://dbpedia.org/resource/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT DISTINCT ?developerName ?games ?string
WHERE {
  res:World_of_Warcraft dbo:developer ?uri . 
  ?uri rdfs:label ?developerName .
  ?uri dbo:product ?games .
  OPTIONAL { ?games rdfs:label ?string . FILTER (lang(?string) = 'en') }
  FILTER (lang(?developerName) = 'en')
}

Softwares developed in California that run on Linux.sparql

PREFIX dbo: <http://dbpedia.org/ontology/>
PREFIX res: <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 DISTINCT ?uri ?string 
WHERE { 
?company rdf:type dbo:Organisation  .
?company dbo:foundationPlace res:California .
?uri rdf:type dbo:Software .
?uri dbo:operatingSystem ?operatingSystem .
FILTER(?operatingSystem = res:Linux)
OPTIONAL { ?uri rdfs:label ?string . FILTER (lang(?string) = 'en') }
} limit 100