SQL Questions on the Northwind Database

SQL Practice Questions

All the questions here are based on the Northwind Sample Database provided with MS SQL Server.

You can download the sql file here.

Northwind SQL

MySQL is best installed using XAMPP which can be found here.

Downloads

Import it into the MySQL Server by following the steps here.

Here is an ER Diagram of the Northwind Database generated by pressing More/Designer in Phpmyadmin

We will start with 2 tables, namely

categories and products.

Questions

1. Find the number of products per category
   
   
   
   
   

Contact us for software training, education or development