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 A.lsc_code='G03' ) AS T ORDER BY PRO_RANKING ASC 현윤진 김승주 한강현