question: What is ASTC Member, when State is Arkansas, when AAM Member is No, and when AAM Accredited is Yes?
answer: SELECT astc_member FROM table_name_39 WHERE state = "arkansas" AND aam_member = "no" AND aam_accredited = "yes"
context: CREATE TABLE table_name_39 (astc_member VARCHAR, aam_accredited VARCHAR, state VARCHAR, aam_member VARCHAR)