Which is the class A when Weslaco was the class AAAAA and brownwood was the class AAAA
create table table_14747043_1 (class_a varchar, class_aaaaa varchar, weslaco varchar, class_aaaa varchar, brownwood varchar, PRIMARY KEY (class_a))
select class_a from table_14747043_1 where class_aaaaa = weslaco and class_aaaa = brownwood