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