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