select
    PREFECTURE.PF_CODE as 都道府県コード,
    PREFECTURE.PF_NAME as 都道府県名,
    round(
        100.0 * INP_YES / (INP_YES + INP_NO + UNIDENTIFIED),
        1)
        as 入院率
from HOSPITALIZATION
    inner join PREFECTURE
    on HOSPITALIZATION.PF_CODE = PREFECTURE.PF_CODE
order by 入院率 desc,
         substr("00000" || PREFECTURE.PF_CODE, -5) asc