CREATE TABLE table_14747043_1 (class_a VARCHAR2, class_aAAAA VARCHAR2, Weslaco VARCHAR2, class_aAAA VARCHAR2, Brownwood VARCHAR2)

Which is the class A when Weslaco was the class AAAAA and brownwood was the class AAAA
SELECT class_a FROM table_14747043_1 WHERE class_aAAAA = Weslaco AND class_aAAA = Brownwood
SELECT "class_a" FROM "table_14747043_1" WHERE "Brownwood" = "class_aAAA" AND "Weslaco" = "class_aAAAA"