SQL Zoo Solutions

Here is a collection of my solutions to the exercises from the SQL Zoo website.

SELECT Basics

SELECT from world

SELECT from nobel

SELECT in SELECT

SUM and COUNT

JOIN

This section uses the database euro2012.sql. It contains three tables: game, goal and eteam. The tables contain all matches and goals from UEFA EURO 2012 Football Championship in Poland and Ukraine.

1. [SQL query]: Show the matchid and player name for all goals scored by Germany.
2. [SQL query]: Show id, stadium, team1, team2 for just game 1012.
3. [SQL query]: Show the player, teamid, stadium and mdate for every German goal.
4. [SQL query]: Show the team1, team2 and player for every goal scored by a player called Mario.
5. [SQL query]: Show player, teamid, coach, gtime for all goals scored in the first 10 minutes.
6. [SQL query]: List the dates of the matches and the name of the team in which 'Fernando Santos' was the team1 coach.

More JOIN

Using NULL

Self JOIN