SELECT
    HOSP.PF_CODE AS '都道府県コード',
    PF_NAME AS '都道府県名',
    /*syntax error*/
    ROUND(CAST(HOST.INP_YES) / CAST(HOST.INP_YES + HOST.INP_NO + HOST.UNIDENTIFIED) * 100, 1) AS '入院率'
FROM
    HOSPITALIZATION AS HOSP
INNER JOIN PREFECTURE AS PRF
    ON PRF.PF_CODE = HOSP.PF_CODE
ORDER BY 
    '入院率' DESC,
    HOSP.PF_CODE ASC