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