SELECT astc_member FROM table_name_39 WHERE state = "arkansas" AND aam_member = "no" AND aam_accredited = "yes"
Apa anggota ASTC, ketika Negara adalah Arkansas, ketika anggota AAM tidak, dan ketika AAM terakreditasi ya?
CREATE TABLE table_name_39 (astc_member VARCHAR, aam_accredited VARCHAR, state VARCHAR, aam_member VARCHAR)