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