select HOSPITALIZATION.PF_CODE as "都道府県コード", 
        PF_NAME as "都道府県名", 
        ROUND(
        CAST(INP_YES as REAL) / 
        CAST(INP_YES + INP_NO + UNIDENTIFIED as REAL)
        * 100
        , 1
        ) as "入院率"
from HOSPITALIZATION
INNER JOIN PREFECTURE
    ON HOSPITALIZATION.PF_CODE = PREFECTURE.PF_CODE
ORDER BY "入院率" desc