select HOSPITALIZATION.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, HOSPITALIZATION.PF_CODE;