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