You will use AdventureWorks2014 database to code the following queries. 1. Write a query that list the ProductID, Name, Color, and listPrice of all products without null values in color. **Sort your output result to show products with higher listprice first. [4 pts] 2. Write a query to list all products with a name starting with h and ending with e. [2 pts] 3. Where did the racing socks go? List the product name and the customer First name and last name for all customers who ordered ProductModel 'Racing Socks'. [5 pts] 4. Write a query to display all sales persons with the same bonus. Your query must show the BusinessEntitylD, TerritoryID and bonus. [4 pts] ** Filter your results to NOT include bonus with value zero. ** Table: [Sales]. [SalesPerson 5. Find the list of employees with the highest pay rate in each pay frequency. Show the business ID, the rate and the pay frequency. [5 pts] ** Table: [Humanesources]. [EmployeePayHistory 6. Find the list of persons without a credit card. Show their Id, first Name and last Name. ** Tables: [Person]. [Person] AND [Sales]. [PersonCreditCard] [3 pts] 7. Find the province name with the lowest tax rate. [4 pts] ** Table: [Person]. [StateProvince] AND [Sales]. [SalesTaxate] 8. Modify the quantity to 5 for the ShoppingCartid: 14951 [3 pts] 9. Add a new row to the table [Sales].[Shopping Cartitem] as follows: [4 pts] - - - [ShoppingCartItemID]: 9 [ShoppingCartID1:20623 [Quantity]:2 [ProductID]: 882 [DateCreated]: System date [ModifiedDate]: System date 10. Remove all rows from the table [Sales] [Shopping Cartitem] [3 pts]