select 
PF_CODE as '都道府県コード',
PF_NAME as '都道府県名',
y_ritu as '入院率'
from 
(select 
A.PF_CODE,
A.PF_NAME,
round(CAST(b.INP_YES AS REAL)/CAST(b.INP_YES+b.INP_NO+b.UNIDENTIFIED AS REAL)*100,1) as y_ritu
from PREFECTURE a,HOSPITALIZATION b
where a.pf_code = b.pf_code) as sub
order by y_ritu DESC,pf_code ASC;