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
    入院率 DESC
    , a.PF_CODE ASC;