Examine the description of the CUSTOMERS table:
You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters.
Which query can be used?
A. SELECT * FROM customers WHERE city = ‘D_%’;
B. SELECT * FROM customers WHERE city LIKE ‘D_’;
C. SELECT * FROM customers WHERE city LIKE ‘D_%’;
D. SELECT * FROM customers WHERE city = ‘%D_’;
C
All sentences are WRONG!
The letter C shows also the names with one character.
C