The following project is comprised of a series of SQL queries which ask specific business related questions (The Northwind database contains sales data about a fictitious company).

How to access the dataset

Northwind is publicly available directly from MariaDB database.

1. Open your favorite MariaDB client (I recommend Dbeaver)
2. Use following credentials:
   • hostname: relational.fit.cvut.cz
   • port: 3306
   • username: guest
   • password: relational
3. Export "northwind" database (or other version of the dataset, if available) in your favourite format (e.g. CSV or SQL dump).

It follows this structure:

1. Business question
2. Translated into SQL query
3. Results → data

First of all, it is important to gather an overview of the data by creating/looking at the entity-relationship diagram of the database:

1. Question: How would you display all of the gross sales for year 2015 made by the companies?

production.suppliers > companyname