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;