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 order that such employee has created.
  4. for each shipper, compute the number of orders handled
  5. compute the orders shipped to the state of Nevada (NV)
  6. find all orders that do not have an invoice