Create the following SQL Server queries that access the Northwind database on the apmycs4.apsu.edu server.

1. The employee id, employee first name, employee last name, and number of orders taken for each employee in 1996. Place the list in descending order by the number of employees.

2. The order id, customer name, order date, and total cost of all items ordered for all orders shipped in July or August 1996. Place the list in descending order by the total cost.

3. The customer id, company name, number of orders, and total order amount for all customers who purchased an item in the Beverages category.

4. Same as problem 3 but, limit the list to all customers who placed 3 or more orders.

5. The product id, product name, last date that the product was ordered for all items in the Grains/Cereals category. (Hint: Use MAX)

6. The product ID, product name, and number of distinct customers who ordered that product in 1996