===========================
SPARQL Queries over DBpedia
===========================

------------------------------------------------------------------------
 1. Who are the living actors starred in the movie Reservoir Dogs and
    what is their age? Write the query in such a way that it gives the
    correct answer, independently of the year when it is
    asked.


------------------------------------------------------------------------
 2. Which of the two actors Steve Buscemi and Nicolas Cage has starred
    in the longest movie (measured in minutes runtime)?


------------------------------------------------------------------------
 3. Between David Mamet, Raymond Chandler and Pauline Kael, who
    influenced most people?


------------------------------------------------------------------------
 4. Which persons have the same last name as the author of book "The
    Little Sister"?  (Assume that the name of a person is the last
    word of the rdfs:label of the resource corresponding to the
    person.)


------------------------------------------------------------------------
 5. Who are the ancestors of Elizabeth II?


------------------------------------------------------------------------
 6. Which ancestors of Elizabeth II were born in 18th century?


------------------------------------------------------------------------
 7. Who are the ancestors of Elizabeth II along the male line (that
    is, father, father's father, etc.)?


------------------------------------------------------------------------
 8. Who are most ancient ancestors of Elizabeth II, that is, ancestors
    for whom no ancestor is known by dbpedia?  Return the most ancient
    ancestors with their name and, if possible, with their birth year
    and year of death.


------------------------------------------------------------------------
 9. Return all women novelists and classify them based on their
    productivity: A for authoring > 15 books, B for authoring 5-15
    books and C for authoring < 5 books.


------------------------------------------------------------------------
 10. Find the name of Italy in all EU languages.


------------------------------------------------------------------------
 11. For each continent, find the country with the largest area.


------------------------------------------------------------------------
 12. Create a table of all countries, if possible with the continent on
    which the country is located, the area of the country, the
    population of the country, and the capital. Group the countries
    first by continent, then by area.  If a country is located on more
    than one continent, let it appear in the groups of all continents
    on which it is located.


------------------------------------------------------------------------
 13. For Asian Games 2010, produce a table that lists for each
    participating country the number of medals it obtained and the
    number of medals per capita.  Rank the countries according to the
    number of medals per capita.