SELECT
 HOS.PF_CODE 都道府県コード
 , PRE.PF_NAME 都道府県名
 , ROUND(CAST(INP_YES AS REAL) / CAST( (INP_YES + INP_NO + UNIDENTIFIED) AS REAL ) * 100, 1) 入院率
FROM HOSPITALIZATION HOS
INNER JOIN PREFECTURE PRE
ON PRE.PF_CODE = HOS.PF_CODE
ORDER BY 入院率 DESC, HOS.PF_CODE ASC