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;