with xx as ( select 
    h.PF_CODE 
    ,PF_NAME 
    ,cast(INP_YES as real) as INP_YES
    ,cast(INP_NO as real) as INP_NO
    ,cast(UNIDENTIFIED as real) as UNIDENTIFIED
from HOSPITALIZATION h left outer join PREFECTURE p on h.PF_CODE=p.PF_CODE
)
select 
    PF_CODE as "都道府県コード"
    ,PF_NAME as  "都道府県名"
    ,round(INP_YES*100/(INP_YES+INP_NO+UNIDENTIFIED),1) as "入院率"
from xx
order by 3 desc,1 asc