SELECT
    A.PF_CODE AS 都道府県コード,
    A.PF_NAME AS 都道府県名,
    ROUND(CAST(B.INP_YES AS DOUBLE) /  CAST(B.INP_YES + B.INP_NO + B.UNIDENTIFIED AS DOUBLE) * 100,1)  AS 入院率
FROM
    PREFECTURE A
INNER JOIN
    HOSPITALIZATION B
  ON A.PF_CODE = B.PF_CODE
 ORDER BY
 入院率 DESC,
 CAST(A.PF_CODE AS INTEGER) ASC
;