SELECT
  P.PF_CODE AS '都道府県コード',
  P.PF_NAME AS '都道府県名',
  ROUND((1.0*H.INP_YES/(H.INP_YES + H.INP_NO + H.UNIDENTIFIED))*100,1) AS '入院率'
FROM
  PREFECTURE AS P
LEFT JOIN
  HOSPITALIZATION AS H
USING
  (PF_CODE)
ORDER BY
    3 DESC,
    1 ASC
LIMIT
  5;