SELECT
    h.PF_CODE AS 都道府県コード,
    PF_NAME AS 都道府県名,
    ROUND(INP_YES / (INP_YES * 1.0 + INP_NO + UNIDENTIFIED) * 100.0, 1) AS 入院率 
FROM HOSPITALIZATION h
    JOIN PREFECTURE p
        ON h.PF_CODE = p.PF_CODE
ORDER BY
    入院率 DESC,
    h.PF_CODE ASC;