select 
    p.pf_code as 都道府県コード,
    p.pf_name as 都道府県名,
    round(cast(INP_YES as real)/cast(INP_YES+INP_NO+UNIDENTIFIED as real)*100,1) as 入院率
from PREFECTURE as p 
LEFT OUTER join HOSPITALIZATION as h
ON p.pf_code = h.pf_code
order by 入院率 desc,都道府県コード