The CUSTOMERS table has these columns: A promotional sale is being advertised to the
customers in France. Which WHERE clause identifies customers that are located in
France?
A.
WHERE lower(country_address) LIKE %france%
B.
WHERE lower(country_address) = “france”
C.
WHERE lower(country_address) = ‘france’
D.
WHERE lower(country_address) IS ‘france’
E.
WHERE lower(country_address) = ‘%france%’