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’