CREATE TABLE table_14747043_1 (class_a VARCHAR, class_aA VARCHAR, Marion VARCHAR)

Which is the class A when Marion was the class AA
SELECT class_a FROM table_14747043_1 WHERE class_aA = Marion
SELECT "class_a" FROM "table_14747043_1" WHERE "Marion" = "class_aA"