SELECT PREFECTURE.PF_CODE as '都道府県コード', PREFECTURE.PF_NAME as '都道府県名', ROUND(CAST(IFNULL(INP_YES,0) AS FLOAT) * 100 / (IFNULL(INP_YES,0) + IFNULL(INP_NO,0) + IFNULL(UNIDENTIFIED,0)), 1) as '入院率' FROM HOSPITALIZATION, PREFECTURE WHERE HOSPITALIZATION.PF_CODE = PREFECTURE.PF_CODE ORDER BY 入院率 DESC, 都道府県コード;