select 
    prefecture.pf_code as 都道府県コード, 
    prefecture.pf_name as 都道府県名,
    round(
        100
        * cast(hospitalization.inp_yes as real) 
        / cast((hospitalization.inp_yes + hospitalization.inp_no + hospitalization.unidentified)
        as real)
        , 1)
    as 入院率
from prefecture
    inner join hospitalization
        on 
        prefecture.pf_code = hospitalization.pf_code
order by
    入院率 desc
    , hospitalization.PF_CODE ASC;