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