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