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