SELECT PRO_NAME FROM (SELECT DISTINCT PRO_NAME, PRO_RANKING FROM VSO_PROFESSOR B LEFT JOIN VSO_LECTURE A ON A.PRO_CODE = B.PRO_CODE where B.pro_view='Y' and A.lec_view='Y' and B.SEC_TIME = 3 and A.sub_code='S03' and A.lsc_code='G03' ) AS T ORDER BY PRO_RANKING ASC 김승주