SELECT 
    p.PF_CODE as '都道府県コード',
    PF_NAME as '都道府県名',
    round(cast(h.INP_YES as REAL) / (h.INP_YES + h.INP_NO + h.UNIDENTIFIED) * 100, 1) as '入院率'
FROM
    HOSPITALIZATION as h
LEFT OUTER JOIN
    PREFECTURE as p
ON
    h.PF_CODE = p.PF_CODE
ORDER BY
    入院率 DESC, 都道府県コード ASC