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