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