select 
    p.PF_CODE as "都道府県コード", 
    p.PF_NAME as "都道府県名", 
    ROUND(CAST(h.INP_YES as real) / (h.INP_YES + h.INP_NO + h.UNIDENTIFIED) * 100, 1) as "入院率"
from 
    PREFECTURE as p
inner join
    HOSPITALIZATION as h
where
    p.PF_CODE = h.PF_CODE
order by
    "入院率" desc, "都道府県コード" asc;