select 
 PREF.PF_CODE AS 都道府県コード
,PREF.PF_NAME AS 都道府県名
,ROUND(((SUM(HOSP.INP_YES)/(SUM(HOSP.INP_YES)+SUM(HOSP.INP_NO)+SUM(HOSP.UNIDENTIFIED)+1.0))*100),1) AS 入院率
from
 HOSPITALIZATION HOSP
inner join 
 PREFECTURE PREF
on
 HOSP.PF_CODE = PREF.PF_CODE
group by 
 PREF.PF_CODE,PREF.PF_NAME
order by 
 入院率 DESC
,都道府県コード
;