Q123 You want to display details of all customers who reside in cities starting with the letter D

Q123 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 LIKE ‘D_%’;
• (B). SELECT * FROM customers WHERE city = ‘%D_’;
• (C). SELECT * FROM customers WHERE city LIKE ‘D_’;
• (D). SELECT * FROM customers WHERE city = ‘D_%’;