SELECT PREFECTURE.PF_CODE AS 都道府県コード,PF_NAME AS 都道府県名 ,ROUND(100.0 * (INP_YES)/(INP_YES+INP_NO+UNIDENTIFIED),1) AS 入院率 FROM PREFECTURE INNER JOIN  HOSPITALIZATION ON PREFECTURE.PF_CODE=HOSPITALIZATION.PF_CODE ORDER BY ROUND(100.0 * (INP_YES)/(INP_YES+INP_NO+UNIDENTIFIED),1) DESC,PREFECTURE.PF_CODE DESC;