select PF.PF_CODE as 都道府県コード, PF.PF_NAME as 都道府県名, round(100*CAST(HP.INP_YES as real)/CAST(HP.INP_YES + HP.INP_NO + HP.UNIDENTIFIED as real), 1) as 入院率
from HOSPITALIZATION as HP
    INNER JOIN PREFECTURE as PF
        on HP.PF_CODE = PF.PF_CODE
order by 入院率 DESC, 都道府県コード ASC;