select
    HOSPITALIZATION.PF_CODE as '都道府県コード',
    PREFECTURE.PF_NAME as '都道府県名',
    ROUND(
        INP_YES * 100.0 /(INP_YES + INP_NO + UNIDENTIFIED),
        1
    ) as '入院率'
from
    HOSPITALIZATION
    inner join PREFECTURE on HOSPITALIZATION.PF_CODE = PREFECTURE.PF_CODE
order by
    ROUND(
        INP_YES * 100.0 /(INP_YES + INP_NO + UNIDENTIFIED),
        1
    ) desc,
    HOSPITALIZATION.PF_CODE asc