WITH NYUIN AS (
    SELECT PF_CODE, round(INP_YES*100.0/(INP_YES+INP_NO+UNIDENTIFIED), 1) AS RATE
    FROM HOSPITALIZATION
)

SELECT NYUIN.PF_CODE AS 都道府県コード, PREFECTURE.PF_NAME AS 都道府県名, NYUIN.RATE AS 入院率
FROM NYUIN
LEFT JOIN PREFECTURE ON NYUIN.PF_CODE = PREFECTURE.PF_CODE
ORDER BY RATE DESC, NYUIN.PF_CODE