select
p.pf_code as '都道府県コード',
p.pf_name as '都道府県名',
round(100*cast(inp_yes as real)/cast((inp_yes+inp_no+unidentified) as ral),1) as '入院率'
from
hospitalization h,
PREFECTURE p
where h.PF_CODE = p.PF_CODE
order by 3 desc