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
    , HOSPITALIZATION.PF_CODE asc;