SELECT
    T01.PF_CODE AS 都道府県コード
  , T02.PF_NAME AS 都道府県名
  , T01.入院率
FROM
    (
    SELECT
        PF_CODE
      , ROUND(cast(INP_YES as real)/cast((INP_YES+INP_NO+UNIDENTIFIED) as real) *100, 1) AS 入院率
    FROM
        HOSPITALIZATION
    ) T01
  , PREFECTURE T02
WHERE
    T01.PF_CODE = T02.PF_CODE
ORDER BY
    入院率 Desc
  , 都道府県コード