Create the following SQL Server queries that access the Northwind database.$$Place them in $.$txt format. Note: These problems all require aggregate processing with GROUP BY$.$

$-$For each employee, list the employee ID$,$ employee first name, employee last name, and count of orders taken in $1996.$ Place the list in descending order by the count of orders.

$-$For all orders shipped in July or August, $1996,$ list the order ID$,$ company name, order date, and total cost of all items ordered. Place the list in descending order by the total cost.

$-$For all customers from the USA, list the customer ID$,$ company name, state, count of orders, and total order amount. Do not consider the discount. Place the list in order by state and then customer ID$,$ but limit the list to all customers who placed $3$ or more orders.

$-$For all$$items in the$$Grains$/$Cereals category, list the product ID$,$ product name, supplier name, and last date that the product was ordered. Order the list by supplier name and product name $($Hint: Use MAX and be sure to include all necessary tables$)$

$-$The product ID$,$ product name, and count of distinct customers who ordered that product in $1996.$ Place the list in descending order by the count of customers.