檢查 MEMBERS 表的結構:NameNull?Type ------------------------------------------------------------ MEMBER_IDNOT NULLVARCHAR2 (6) FIRST_NAMEVARCHAR2 (50) LAST_NAMENOT NULLVARCHAR2 (50) ADDRESSVARCHAR2 (50) CITYVARCHAR2 (25) STATEVARCHAR2 (3) 您想顯示居住在以字母 A 開頭、後跟一個字符的州的所有成員的詳細信息。必須執行哪條 SQL 語句?
A. ELECT * FROM MEMBERS WHERE state LIKE '%A_*;
B. ELECT * FROM MEMBERS WHERE state LIKE 'A_*;
C. ELECT * FROM MEMBERS WHERE state LIKE 'A_%';
D. ELECT * FROM MEMBERS WHERE state LIKE 'A%';