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