select 
    H.PF_CODE as "都道府県コード",
    P.PF_NAME as "都道府県名",
    ROUND((CAST(H.INP_YES as float) / CAST((H.INP_YES + H.INP_NO + H.UNIDENTIFIED) as float)) * 100, 1) as "入院率"
from 
    HOSPITALIZATION as H 
    join PREFECTURE as P 
    on H.PF_CODE = P.PF_CODE
order by 
    "入院率" desc,
    H.PF_CODE;