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