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?

The correct answer is B. WHERE lower(country_address) = 'france'. WHERE lower(country_address)='france'

Restricting and Sorting Data

Question

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?

(44 responses)

WHERE lower(country_address)='france'

#LOWER function#WHERE clause#string comparison#single quotes

No community discussion yet for this question.