select MM.PF_CODE as 都道府県コード, MM.PF_NAME as 都道府県名, 
round(CAST(MM.INP_YES as double) / CAST((MM.INP_YES + MM.INP_NO + MM.UNIDENTIFIED) as double) * 100, 1)
as 入院率
from 
(HOSPITALIZATION as HO
join
PREFECTURE as PR
on HO.PF_CODE = PR.PF_CODE) as MM
order by 入院率 desc, 都道府県コード