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