1. What is the total amount (Qty_purchased * Purchase_Price) of all products on each order? Display the order number and the total amount. Rename the calculated column to "Total Amount". 2. What is the Product description of the product that has the highest "Qty Purchased" on any specific order? 3. How many sales representatives are there in each department? Display the full department name and the number of sales representatives. Rename the calculated field as "Number of Employees". Order the output by Number of Employees in ascending order. 4. Which product (Product Number and Description) has the highest Quantity on hand amount? 5. Which customers have placed more than three orders? (Display the customer number and the number of orders). 6. Display all the order numbers of orders that were ordered in the year 2001. 7. Display the names of the sales representatives that have taken more than 3 orders. (Display the sales representatives Surname and First Name and the count. 8. List all the orders that were not taken by sales representative 'Bill Smith'. Display the Order Number and Order Date for each order. 9. What product has the second highest unit price? Display the Product Number and the Description. 10. What is the name (First name and Surname) of the customer who placed the order 12666? 11. How many times has the Product with product number 'DP03' been ordered? 12. Are there any products that have not been ordered? List the product number and product name. 13. What are the names (First and Surname) of the customers that have ordered a product described as a 'Walkman'? 14. Display all details of products that have a quantity on hand of greater than 10 and a unit price of greater than 100 dollars. 15. What is the name (last name and First Name) of the sales representative that is assigned to order 12630? 16. How many orders were taken by sales person 'S2' in the year 2002? 17. How many orders are assigned to each order status? Display the order status and the count in ascending order by order status 18. For each order, how many different products were ordered? Display the Oder Number and Count. 19.For each sales representative, display their name (First and Surname) and the name of the department they are assigned to. 20 Display the product number and description of all products that have a unit price greater than thirty dollars and a quantity on hand of less than 20..