SELECT HOS.PF_CODE as 都道府県コード, PRE.PF_NAME as 都道府県名,
round(cast(HOS.INP_YES as float) / (HOS.INP_YES + HOS.INP_NO + HOS.UNIDENTIFIED) * 100,1) as 入院率
FROM HOSPITALIZATION HOS
INNER JOIN PREFECTURE PRE
ON HOS.PF_CODE = PRE.PF_CODE
order by 入院率 desc, 都道府県コード asc;