9- The SQL SELECT statement performs case-sensitive comparisons. a. True b. False When used in a parameter query, which of the following WHERE clauses will select the records for employees working more than 40 hours? a. WHERE Hours Hours b. WHERE Hours Hours C. WHERE Hours > #Hours d. WHERE Hours > Hours 10. Which of the following calculates the average of the values in the OnHand field? a. SELECT AVERAGECOnHand) AS Available FROM dbo.Inventory b. SELECT OnHand.AVG AS Available FROM dbo.Inventory C. SELECT AVGCOnHand) AS Available FROM dbo. Inventory d. SELECT AVG.OnHand AS Available FROM dbo.Inventory 11. Which of the following calculates a 10% commission on the values in the Sales field and then stores the results in the Commission field? a. SELECT Year, Sales, Commission -Sales0.1 FROM dbo.TrentSales b. SELECT Year, Sales, AS Commission-Sales0.1 FROM dbo.TrentSales c. SELECT Year, Sales, Sales 0.1 Commission FROM dbo.TrentSales d. SELECT Year, Sales, Sales 0.1 AS Commission FROM dbo . TrentSales 12