we have to provide the description of pc

relational database

vill 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. TerritorylD and bonus. [4 pts] " Filter your results to NOT include bonus with value zero. " Table: [5ales]-[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: [Hunankesources]-[Enployeepaytistory] 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 wath the lowest tax rate. [4 pts] "Table: [Person] [Statefrovince] no [sales].[salestankate] 8. Modify the quantity to 5 for the ShoppingCartid: 14951 [3 pts] 9. Add a new row to the table [Sales].[ShoppingCartitem] as follows: [4 pts] - IShoppingcartiteniDis? - [shopp tnecartiD] 126623 - [euantity]:2 - [Product10]:68z - [0atecreated]: Systen date - (Wodifirobato] : Systen date 10. Remove all rows from the table [Sales].[Shopping Cartitem] [3 pts]