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