WITH a AS(
SELECT
    PF_CODE AS "都道府県コード",
    PF_NAME AS "都道府県名",
    ROUND(100.0 * INP_YES / (INP_YES + INP_NO + UNIDENTIFIED), 1) AS "入院率"
FROM HOSPITALIZATION
LEFT JOIN PREFECTURE USING(PF_CODE)
)
SELECT * FROM a
ORDER BY 3 DESC, 1