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