select a.PF_CODE as 都道府県コード, b.PF_NAME as 都道府県名,
    ROUND(
        cast(a.INP_YES as real) / cast((a.INP_YES + a.INP_NO + a.UNIDENTIFIED) as real) * 100, 1) as 入院率
    from HOSPITALIZATION a 
    inner join PREFECTURE b on a.PF_CODE = b.PF_CODE
    order by 入院率 desc, 都道府県コード;