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