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