select 
pf_code as "都道府県コード",
pf_name as "都道府県名",
round(
INP_YES*100.0/(INP_YES+INP_NO+UNIDENTIFIED), 1
) as "入院率"
from HOSPITALIZATION
left join PREFECTURE using(pf_code)
order by 3 desc, 1