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