select
    PREFECTURE.PF_CODE as "都道府県コード"
    , PF_NAME as "都道府県名"
    , cast((1000 * INP_YES / (INP_YES + INP_NO + UNIDENTIFIED)) as "float") / 10 as "入院率"
from
    PREFECTURE
left join
    HOSPITALIZATION
on
    PREFECTURE.PF_CODE = HOSPITALIZATION.PF_CODE
where
    INP_YES is not null
order by
    cast((1000 * INP_YES / (INP_YES + INP_NO + UNIDENTIFIED)) as "float") / 10 desc
    , PREFECTURE.PF_CODE