select 
PF_CODE as "都道府県コード"
,PF_NAME as "都道府県名"
,rate as "入院率"
from (select 
p.PF_CODE
,p.PF_NAME
,cast(sum(cast(h.INP_YES as float) / (h.INP_YES + h.INP_NO + h.UNIDENTIFIED) * 100) as interger) as "rate"
from HOSPITALIZATION h
inner join PREFECTURE p on h.PF_CODE = p.PF_CODE
group by h.PF_CODE ) as tmp
order by rate desc, PF_CODE asc
;