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