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