select p.PF_CODE as 都道府県コード, p.PF_NAME as 都道府県名, 
cast(round(100 * h.INP_YES/(cast(h.INP_YES as REAL) + h.INP_NO + h.UNIDENTIFIED),1) as CHAR ) + 0  as 入院率
from HOSPITALIZATION as h
join PREFECTURE as p
on h.PF_CODE = p.PF_CODE
order by 入院率 DESC, 都道府県コード ASC
;