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