WITH RATE_HOS AS (
  SELECT PF_CODE,
    ROUND(CAST(INP_YES AS REAL) * 100 / (CAST(INP_YES AS REAL) + CAST(INP_NO AS REAL) + CAST(UNIDENTIFIED AS REAL)) , 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;