Skip to content

oakmac/northwind-sql-questions

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

1 Commit
 
 

Repository files navigation

Northwind SQL Questions

From YugabyteDB:

The Northwind database is a sample database that was originally created by Microsoft and used as the basis for their tutorials in a variety of database products for decades. The Northwind database contains the sales data for a fictitious company called “Northwind Traders,” which imports and exports specialty foods from around the world. The Northwind database is an excellent tutorial schema for a small-business ERP, with customers, orders, inventory, purchasing, suppliers, shipping, employees, and single-entry accounting. The Northwind database has since been ported to a variety of non-Microsoft databases, including PostgreSQL.

You can find a copy of the northwind database for PostgreSQL here.

Practice Questions that require JOINs

  • Who are our suppliers who provide Beverages?
  • Who are our suppliers who provide Confections?
  • How many orders were there in the Tampa territory for Q2 1997? (Q2 is April 1 - June 30)
  • Which employees have sold orders to customers in Germany?

About

practice SQL questions for the Northwind database

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published