select
 PF.PF_CODE as 都道府県コード
,PF.PF_NAME as 都道府県名
,round(
cast(HO.INP_YES as real) / (
  + cast(HO.INP_YES as real)
  + cast(HO.INP_NO  as real)
  + cast(HO.UNIDENTIFIED as real)
  ) * 100
 ,1) as  入院率
-- ,都道府県毎の入院率 as 入院率
from 
PREFECTURE as PF
left join HOSPITALIZATION as HO
on PF.PF_CODE = HO.PF_CODE
order by 入院率 desc ,都道府県コード