1. Create a query that returns the first and last name of each employee and a count of how many orders they have placed.

2. Create a query that returns the unique combinations of customers (companyname) have bought what products (productname) that is I dont want duplicate customer-product combinations.

3. Create a query that returns what customers (contactname) have placed more than 20 orders.

4.Create a query that, that updates the price of all products by 10%

5. Create a query that returns all companies (CompanyName) from both our suppliers and our customers that we do business with.

6. Create a query that returns all companies (CompanyName) from both our suppliers and our customers that we do business with in Germany.

7. Create a query that shows the 3 most expensive products (ProductName and UnitPrice).

8. Create a query that shows the 10 most expensive orders (unitprice * quantity is sufficient for the calculation), make sure to output both the OrderID and the total order price.

9. Create a query that finds the CompanyName of all the customers that did not buy anything in 1998.