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