List the customer number and name for all customers located in the city of Grove. Your query should ignore case. For example, a customer with the city Grove should be included as should customers whose city is GROVE, grove, GrOvE, and so on.
Can someone explain if I am doing this correctly. Thanks
My Answer:
SELECT CUST_NUM, CUST_NAME
FROM CUSTOMER
WHERE UPPER (CITY) = UPPER(GROVE);