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