select
    hosp.pf_code as 都道府県コード,
    pref.pf_name as 都道府県名,
    hosp.covid_pt as 入院率
from
    prefecture pref 
left outer join (
    select
        pf_code,
        round(cast(inp_yes as real) / (inp_yes + inp_no + unidentified) * 100, 1) as covid_pt
    from
        hospitalization
) hosp
on pref.pf_code = hosp.pf_code
where
    hosp.pf_code is not null
order by hosp.covid_pt desc, hosp.pf_code;