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