SQL

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)

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)

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)

4.Select Business Entity ID and the vacation hours for all employees with vacation time between 41 and 100 hours. (HumanResources.Employee)

5. Select Product ID, name, and weight for all products with a weight between 1 and 15. (Production.Product

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))