Exercise

Exercise

On the NorthWind database:

1. find all employees that have created at least a purchase
2. find all employees that have created at least 2 purchases
3. for each employee, compute the overall shipping fees of the purchase orders that such employee has created.
4. for each shipper, compute the number of orders handled
5. compute the orders shipped to the region “Western Europe”
6. find all orders that do not have an invoice