As a part of the Udacity Full Stack Web Developer Nanodegree programme, this project was all about designing an SQL database scheme to hold the results of games in an Swiss-system style tournament.
SQL queries had to be designed to support the rules of the Swiss-system (basically, players with a similar number of wins should play each other in the next round).
The SQL queries quickly got quite complicated, so I made use of the
CREATE VIEW command to break the query into more manageable sub-queries.
For more details and to read the code, please visit the project on GitHub here.