select HOSPITALIZATION.PF_CODE  都道府県コード,
PREFECTURE.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 
inner join PREFECTURE on HOSPITALIZATION.PF_CODE = PREFECTURE.PF_CODE

order by 入院率 desc ,
都道府県コード