select
        HOSPITALIZATION.PF_CODE as 都道府県コード,
        PF_NAME as 都道府県名, 
        ROUND(CAST(INP_YES as REAL)/CAST((HOSPITALIZATION.INP_YES + HOSPITALIZATION.INP_NO + HOSPITALIZATION.UNIDENTIFIED) as REAL) * 100, 1) as '入院率'
from 
        HOSPITALIZATION
join
        PREFECTURE
on
        HOSPITALIZATION.PF_CODE  = PREFECTURE.PF_CODE 
order by 
        入院率 DESC, 都道府県コード asc ;