A customer table contains a country code column representing the customer’s country.
There is a corresponding lookup table that captures which country code represents each
country (100=Germany, 101=France. 102=ltaly, and so on). Which rule logic would address
a requirement to find all French customers that have a phone number made up often digits?

A.
countryname = ‘France’ AND phone matches_regexp ‘99.99.99.99.99’

B.
lookup(countryname) = ‘France’ AND phone matches_regexp ‘99.99.99.99.99’

C.
IF lookup(countryname) = ‘France’ THEN phone matches_format ‘99.99.99.99.99’

D.
IF lookup(country. countrycodes. countrynames) = ‘France’ THEN phone
matches_format ‘99.99.99.99.99’