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