%---- RDF

%-- para ejecutarlas en dblp.l3s.de/d2r/snorql/


% -- coautores de claudio

PREFIX : <http://dblp.l3s.de/d2r/resource/authors/>

SELECT DISTINCT ?CoAutor WHERE {
  ?P dc:creator :Claudio_Gutierrez .
  ?P dc:creator ?CoAutor
}

% -- papers publicados por Claudio el 2006

PREFIX : <http://dblp.l3s.de/d2r/resource/authors/>

SELECT DISTINCT ?P WHERE {
  ?P dc:creator :Claudio_Gutierrez .
  ?P dcterms:issued ?D .
  FILTER (?D = 2006)
}

%---- RDF

%-----------------------
%-----------------------
%-----------------------

% para ejecutar en DBPedia en http://dbpedia.org/snorql/

%-----------------------
% - - Personas en Wikipedia con alma mater Universidad de Chile

PREFIX dbpedia-owl: <http://dbpedia.org/ontology/>

SELECT ?X WHERE {
   ?X dbpedia-owl:almaMater  :University_of_Chile .
}

# :Pontifical_Catholic_University_of_Chile
# :University_of_Chile


%-----------------------
% - - Persona con fecha de nacimiento mas antigua que nacio en Chile

PREFIX dbpedia-owl: <http://dbpedia.org/ontology/>

SELECT DISTINCT ?X ?D WHERE {
{ {
    ?X dbpedia-owl:birthPlace :Chile
  }
  UNION
  {
    ?X dbpedia-owl:birthPlace ?Place .
    ?Place dbpedia-owl:country :Chile
} }
    ?X dbpedia-owl:birthDate ?D
    FILTER regex(str(?D), "[1][0-9][0-9][0-9]")
}

ORDER BY ?D 
LIMIT 1


%-----------------------

PREFIX dbpprop: <http://dbpedia.org/property/>
PREFIX dbpedia-owl: <http://dbpedia.org/ontology/>

SELECT ?place ?augRain
WHERE{
 { ?place dbpprop:augPrecipitationMm ?augRain . }
 UNION
 { ?place dbpprop:augRainMm ?augRain .}

 ?place dbpedia-owl:country :Chile .
 ?place rdfs:label ?placeName .
 FILTER (langMatches(lang(?placeName),"en"))
}

ORDER BY DESC(?augRain)
LIMIT 1

%-----------------------

PREFIX dbpedia-owl: <http://dbpedia.org/ontology/>

SELECT DISTINCT ?X ?D WHERE {
{ {
    ?X dbpedia-owl:birthPlace :Chile
  }
  UNION
  {
    ?X dbpedia-owl:birthPlace ?Place .
    ?Place dbpedia-owl:country :Chile
} }
    ?X dbpedia-owl:deathDate ?D
    FILTER regex(str(?D), “1818”)
}


%-----------------------

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

SELECT count(?X) as ?Number, ?Z WHERE 
{
  ?X dbowl:starring :Owen_Wilson .
  ?X dbowl:starring ?Z .
  FILTER (?Z != :Owen_Wilson)
}
GROUP BY ?Z
ORDER BY desc(?Number)
LIMIT 1