Which is the class A when Marion was the class AA
create table table_14747043_1 (class_a varchar, class_aa varchar, marion varchar, PRIMARY KEY (class_a))
select class_a from table_14747043_1 where class_aa = marion