select * from yoon_teacher where trim(tt_txt1)!='' and tt_retire!='Y' and cat_3 = 'G-Telp' group by tt_txt1,tt_name order by tt_rank desc