SELECT
    HO.PF_CODE AS 都道府県コード,
    PR.PF_NAME AS 都道府県名,
    ROUND(
    CAST(HO.INP_YES AS REAL)/CAST((HO.INP_YES + HO.INP_NO + HO.UNIDENTIFIED) AS REAL)*100,1) AS 入院率

FROM HOSPITALIZATION AS HO
    INNER JOIN PREFECTURE AS PR
    ON HO.PF_CODE = PR. PF_CODE

ORDER BY 入院率 DESC,HO.PF_CODE ASC;