select HOSPITALIZATION.PF_CODE, 
        PF_NAME, 
        ROUND(
        CAST(INP_YES as REAL) / 
        CAST(INP_YES + INP_NO + UNIDENTIFIED as REAL)
        * 100
        , 1
        ) as rate
from HOSPITALIZATION
INNER JOIN PREFECTURE
    ON HOSPITALIZATION.PF_CODE = PREFECTURE.PF_CODE
ORDER BY rate desc