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