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