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