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