SELECT
  p.PF_CODE AS '都道府県コード',
  p.PF_NAME AS '都道府県名',
  ROUND(SUM(CAST(h.INP_YES AS REAL)) / (
    SUM(CAST(h.INP_YES AS REAL))
    + SUM(CAST(h.INP_NO AS REAL))
    + SUM(CAST(h.UNIDENTIFIED AS REAL))
  ) * 100, 1) AS '入院率'
FROM PREFECTURE p
INNER JOIN HOSPITALIZATION h USING (PF_CODE)
GROUP BY p.PF_CODE
ORDER BY 入院率 DESC, 都道府県コード ASC