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

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"