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