SELECT PREFECTURE.PF_CODE AS '都道府県コード', PREFECTURE.PF_NAME AS '都道府県名', ROUND(INP_YES * 100.0 / (INP_YES + INP_NO + UNIDENTIFIED), 1) AS '入院率' FROM HOSPITALIZATION INNER JOIN PREFECTURE USING(PF_CODE) ORDER BY '入院率' DESC, '都道府県コード' ASC;