with hos_real as (
    select
        hospitalization.pf_code,
        prefecture.pf_name,
        cast(inp_yes as real) as yes,
        cast(inp_no  as real) as no,
        cast(unidentified  as real) as undef
    from
        hospitalization
        join prefecture on hospitalization.pf_code = prefecture.pf_code
)
select
    pf_code as 都道府県コード,
    pf_name as 都道府県名,
    round( yes / ( yes + no + undef ) * 100, 1 ) as 入院率
from
    hos_real
order by 入院率 desc, pf_code desc
;