--- tags: databases,postgresql,northwind,practical --- # Northwind Practical ## Setup a Northwind PostgreSQL Container Please follow the instructions on here: - [Northwind for PostgreSQL](https://github.com/MCRcodes/be-northwind-postgres) --- ## Solve these challenges Having setup your Northwind container, have a go at solving these challanges: 1. Show list of all discontinued products 1. Show a list of product more expensive than $10, order from most expensive to cheapest 1. What is the most expensive product listed 1. What is the least expensive product listed 1. How much are the most expensive products in each category 1. What is the company name of the supplier of the cheapest product 1. Show a list of employees who work in Sales 1. How many employees exist with job roles below Sales Manager 1. Show number of purchase orders created in the last month 1. Show the total paid to suppliers in the last month ## Entity Relationship Diagram Here is an ERD (entity relationship diagram) so you can see how the tables in Northwind all relate to each other: ![Northwind ERD](https://github.com/MCRcodes/be-northwind-postgres/raw/main/northwind-erd.png)