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