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? 

Answer options:

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%`;

B