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