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