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