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