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