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