select HOSPITALIZATION.PF_CODE as 都道府県コード, PF_NAME as 都道府県名, 
round(cast(SUM(INP_YES) as REAL)/cast((SUM(INP_YES)+SUM(INP_NO)+SUM(UNIDENTIFIED)) as REAL)*100,1) as 入院率
from HOSPITALIZATION
LEFT OUTER JOIN PREFECTURE
 ON HOSPITALIZATION.PF_CODE = PREFECTURE.PF_CODE
group by HOSPITALIZATION.PF_CODE
order by 入院率 desc
;