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