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