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