SQL Practice Problems

This is a nice book that helps anyone working with data the most important skills in SQL queries needed to pull information needed from database tables. Readers unfamiliar with this book can see what others have said here.

I implemented my solutions to these problems in SQLite rather than SQL Server. To get a copy of the Northwind database to work the problems in I went here. Once the files were downloaded to create the database I used the command:

sqlite3 Northwind.db < Northwind.Sqlite3.create.sql # creates the database

There were supposed to be differences between the database provided by the book and the default Northwind database. The only differences I found were the dates seemed to be different and the [CustomerGroupThresholds] table was added. You can create this table by running the SQL here.

To learn this material as well as possible I worked through as many of the book's problems and exercises as I had time to. To formalize my understanding I've put the SQL code in book form. You can find the solutions I have done here.

As always, I am interested in hearing about any errors that might exist in this material.

John Weatherwax