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='G02' ) AS T ORDER BY PRO_RANKING ASC 금동흠