/*
select
    p.pf_code as '都道府県コード'
    ,p.pf_name as '都道府県名'
--    ,h.inp_yes / (h.inp_yes + h.inp_no + h.unidentified) * 100 as '入院率'
    ,h.inp_yes
from
    prefecture p
left join
    hospitalization h
on
    p.pf_code = h.pf_code
order by
    3 desc, 1 asc
*/

select
    *
from
    hospitalization