select
    PREFECTURE.PF_CODE as "都道府県コード",
    PREFECTURE.PF_NAME as "都道府県名",
    round(
        cast(HOSPITALIZATION.INP_YES as REAL) /(
            HOSPITALIZATION.INP_YES + HOSPITALIZATION.INP_NO + HOSPITALIZATION.UNIDENTIFIED
        ) * 100,
        1
    ) as "入院率"
from
    HOSPITALIZATION,
    PREFECTURE
where
    HOSPITALIZATION.PF_CODE == PREFECTURE.PF_CODE
order by
    "入院率" desc,
    "都道府県コード"