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