The following SQL query:
SELECT lastName FROM Authors
WHERE lastName LIKE '%e_'
A) selects from the table Authors the lastName fields which start with any single character followed by an 'e', then any number of additional characters.
B) selects from the table Authors the lastName fields which start with either the letter e followed by any number of additional characters.
C) selects from the table Authors the lastName fields which constist of any number of characters followed by an 'e' and any single character.
D) selects from the table Authors the lastName fields which end with the letter 'e'.

Question

Quizplus · Accepted Answer

The query uses the LIKE pattern '%e_' which matches any string ending with 'e' followed by exactly one character.

The Following SQL Query