SELECT h.PF_CODE AS 都道府県コード, PF_NAME AS 都道府県名, round(cast(INP_YES as real) / (cast(INP_YES as real) + cast(INP_NO as real) + cast(UNIDENTIFIED as real)) * 100, 1) AS 入院率
FROM HOSPITALIZATION h
JOIN PREFECTURE p ON (p.PF_CODE = h.PF_CODE)
ORDER BY 入院率 DESC, 都道府県コード ASC