with t as(
select cast(SUM(Ho.INP_YES) as real ) as YES , cast(SUM(Ho.INP_NO) as real ) as No , cast(SUM(Ho.UNIDENTIFIED) as real ) as UN,Ho.PF_CODE as PF_CODE, Pr.PF_NAME as PF_NAME
from HOSPITALIZATION Ho inner join PREFECTURE Pr on ho.PF_CODE = Pr.PF_CODE 
group by Ho.PF_CODE,Pr.PF_NAME) 
select PF_CODE as '都道府県コード', PF_NAME as '都道府県名', Round(Yes*100/(Yes + No + Un),1) as '入院率' from t order by 入院率 desc, 都道府県コード