Basic conditions

• Size of France
• Size of Germany
• Names of contries
• Populous countries
• European countries
• Large or big countries
• Large or big countries in Europe
• List continents

Basic joins

• Title and release year of a movie
• Who directed 'Lost in Translation'?
• Other movies from the same director
• Actors in Pride and Prejudice
• Movies in which A. Kendrick appears
• Director who directed George Clooney
• Directors who plays in their movies
• Actors who played with Harrison Ford
• Challengers
• Actors who plays in movies for several years
• Directors who often play with the same actor

Basic group by

• Introduction to Group By
• Order and group by
• Order and group by 2
• Order and group by 3
• Big continents
• Number of countries per continent
• Number of countries
• Number of countries with population and area

Ordering results

• Order by name
• Order with two criteria
• Biggest country
• Least populous country
• 100th country
• Movies of Georges Lucas
• Actors of Pride and Prejudice
• Movies with lots of actors
• Years with multiple movies

Subqueries

• Most populous big country
• Biggest country in each continent
• Pareto-optimal
• Movies without castings
• People who are not actors
• People with no movies

Partition over

• Introduction
• Rank in continent

A mix of queries

• Density
• Alpha
• Largest and biggest by continent
• Biggest than largest per continent
• Simon Pegg and Nick Frost
• Actors in Star Wars
• Co-actors of Keira Knightley
• Pareto optimal bis

Recursive queries

• Numbers from 0 to 100
• 2-syracuse

This website was heavily inspired by SQL Zoo and by a previous website made by Antoine Amarilli.