with calc as(
    select h.PF_CODE as "PFC",
            p.PF_NAME as "PFN",
            cast(h.INP_YES as real) as "IY",
            cast(h.INP_YES + h.INP_NO + h.UNIDENTIFIED as real) as "N"
    from HOSPITALIZATION h
        left join
        PREFECTURE p
        using(PF_CODE)
)


select PFC as "都道府県コード",
        PFN as "都道府県名",
        round((IY/N) * 100,1) as "入院率"
from calc
order by 3 desc,1 asc;