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