SELECT
    W.PF_CODE AS '都道府県コード',
    W.PF_NAME AS '都道府県名',
    W.INP_RATE AS '入院率'
FROM (
    SELECT
        CAST(P.PF_CODE AS INTEGER) AS PF_CODE,
        P.PF_NAME,
        CASE IFNULL(H.INP_YES, 0) + IFNULL(H.INP_NO, 0) + IFNULL(H.UNIDENTIFIED, 0) WHEN 0
        THEN 0
        ELSE ROUND(IFNULL(H.INP_YES,0) / CAST(
            IFNULL(H.INP_YES, 0) + IFNULL(H.INP_NO, 0) + IFNULL(H.UNIDENTIFIED, 0)
            AS REAL) * 100, 1)
        END AS INP_RATE
    FROM
      PREFECTURE AS P
      INNER JOIN HOSPITALIZATION AS H
      ON P.PF_CODE = H.PF_CODE
) AS W
ORDER BY
  INP_RATE DESC,
  PF_CODE ASC