Chapter 12, Problem 2RQ

Below are some rows of the PROVIDERS table for a factory: PCODE 10192 98411 0489035 NAME Hans, Inc. Tools and More Motors Inc. PHONE 231 - 3092 231-1029 993 - 1821 All providers from the factory zone of the city start with 231. You want to get the providers that are in the factory zone of the city. Which of the following is more appropriate? O a. O b. SELECT * FROM PROVIDERS WHERE PHONE LIKE '% 231' O C. O d. SELECT * FROM PROVIDERS WHERE PHONE LIKE $231%' SELECT * FROM PROVIDERS WHERE PHONE LIKE 231 SELECT * FROM PROVIDERS WHERE PHONE LIKE '%231%'

Below are some rows of the PROVIDERS table for a factory:   PCODE NAME PHONE 10192 Hans, Inc. 231 - 3092 98411 Tools and More 231 - 1029 0489035 Motors Inc. 993 - 1821   All providers from the factory zone of the city start with 231. You want to get the providers that are in the factory zone of the city. Which of the following is more appropriate?     a. SELECT * FROM PROVIDERS WHERE PHONE LIKE ‘%231%’   b. SELECT * FROM PROVIDERS WHERE PHONE LIKE ‘% 231’   c. SELECT * FROM PROVIDERS WHERE PHONE LIKE ‘___ 231 ___’   d. SELECT * FROM PROVIDERS WHERE PHONE LIKE ‘231%’

7. What gift will a customer who orders the book Shortest Poems receive? Use the actualbook retail value to determine the gift.