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