select hp.PF_CODE AS 都道府県コード
    , pr.PF_NAME AS 都道府県名
    , round((100.00 * INP_YES / (INP_YES + INP_NO + UNIDENTIFIED)),1) AS 入院率
from HOSPITALIZATION hp
    left outer join PREFECTURE pr
        on hp.PF_CODE = pr.PF_CODE
order by 入院率 desc, hp.PF_CODE;