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
;