Schemas, Questions & Solutions for SQL Exercising

The schemas and questions are

[1] from Wikibook SQL Exercises [https://en.wikibooks.org/wiki/SQL_Exercises]. Solutions are from both this Wikibook and me (exercise 1-8). I also added some questions by myself.

or

[2] given by me using some practical examples I encountered (exercise 9-10).

The repo structure is like below:

SQL-exercise
└───SQL_exercise_1
└───......
└───SQL_exercise_*
 │ *_schema_figure.png
 │ *_build_schema.sql
 │ *_questions_and_solutions.sql
└───......

To setup database for practicing, enter the exercise folder (e.g., exercise_01) which you want to practice and start SQLite:

cd SQL_exercise_01
sqlite3

Build tables using SQL script provided with .read dot-command in sqlite shell:

.read 1_build_schema.sql

Start practicing.

Please note this repostory is under the Creative Commons Attribution-ShareAlike License[https://creativecommons.org/licenses/by-sa/3.0/].