15、（6-24）choose the best answer

Examine the structure of the MEMBERS table:

You want to display details of all members who reside in states starting with the letter A followed

by exactly one character.

Which SQL statement must you execute?

A. SELECT * FROM MEMBERS WHERE state LIKE 'A%’;

B. SELECT * FROM MEMBERS WHERE state LIKE 'A_%’;

C. SELECT * FROM MEMBERS WHERE state LIKE 'A_';

D. SELECT * FROM MEMBERS WHERE state LIKE '%A_';

Answer：A

（解析：答案 B 也是可以达到要求，但是不是最好的答案）