EX-06: Write two queries that return the EmplD and Hourly Rate column values for each row in the PayRates table that has a Hourly Rate value between 10 and 25. Make sure that each query uses a different WHERE clause to return the data. SOLUTION-01 : SOLUTION-02: EX-07: You need information on each employee who was hired on November 15, 2001. In order to obtain this information, write a query that returns all column values for each row in the Employee table with a HireDate value equal to '2001-11-15'. SOLUTION: EX-08: Write a query that returns a unique listing of ManagerID values from the Employee table. HINT: You will need to use the keyword DISTINCT in this query. SOLUTION: EX-09: Write a query that returns all of the column values from the Grant table for rows with an EmplD value of 7 and an Amount value that is NOT between 15000 and 30000. SOLUTION: EX-10: Write a query that returns each row in the Current Products table if the row's ProductName indicates the row is for some type of 2 or 3 days product. SOLUTION: EX-11: JProCo is considering a 10% discount on the retail price of each Overnight-Stay product in the Current Products table. Write a query that returns the ProductID, ProductName, RetailPrice and the discounted retail price (90% of RetailPrice). Make sure that the discounted retail price column in the result set has an appropriate column alias. SOLUTION