For all the questions below write SQL query, Submit your queries in one pdf document. You only need to submit the query statement, no need to include resultset. The number at the end of the query statement indicates the number of rows returned by the query. We are using AdventureWorkd 2012 database for this assignment. 1. Select sales order ID, order quantity, unit price, and unit price discount for all orders with a unit price of $3, 578.27, then sort by sales order ID in descending order. (Sales SalesOrderDetail table 1551) 2. Select Business Entity ID, person type, first name, and last name for all persons with first names starting from A through C, then sort those persons by first name in ascending order. (Person Person) (4707) 3. Select Sales Order ID, ship date, and purchase order number for all orders with a ship date during the year 2005, then sort those in ascending order by their sales order ID. (Sales SalesOrderHeader) (1328) 4. Select Business Entity ID and the vacation hours for all employees with vacation time between 41 and 100 hours. (HumanResources.Employee)(178) 5. Select Product ID, name, and weight for all products with a weight between 1 and 15. (ProductionProduct)(86) 6. Select Sales Order ID, unit price, and order quantity for all products with an order quantity of 5, 10, 15, or 20. (Sales SalesOrderDetail) (5319) 7. Select Product ID, name, and size of all products with a size of S, M or L sort the results by name. (Production Product)(31) 8. Select Sales Order ID, order date, subtotal, and total for all orders with a total amount due between 5000 dollars and 9.999.99 sort the results by order date. (Sales.SalesOrderHeader)(393) 9. Select all currency which use the word dollar in the currency name and which are not 'US dollar' (Sales.Currency 14) 10. Show all sales person who have been assigned a sales quota and also have got bonus of more than $3000(Sales.SalesPerson 9) 11. Show all the stores which have sales person with id 275 or 282 or 288 or 277 or 290 (Sales.Store 307) 12. Show all the bike stores worked by sales person id 282 or 275.(e.g. a bike store will have the world bike in the name)(Sales.Store 40) 13.For all products which are listed for less than $20 create a list which shows the name product number in one column. (Production.product 215). For Example if the product is id=922 the result will show Road Tire Tube - TT-R982 14. Show al products which start selling within 2 days of june 1, 2002. (Production. Product 211) 15. Show al products that we start selling in June and may. (Production.Product 211) 16. Show the maximum list price, average list price, maximum standard cost and minimum standard cost. Make sure all columns have a headings.(Production.Product 1)