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