select p.PF_CODE as "都道府県コード", p.PF_NAME as "都道府県名", 
FORMAT((h.INP_YES / (h.INP_YES + h.INP_NO + h.UNIDENTIFIED)) * 100, '##.#') as "入院率"
from PREFECTURE p
join HOSPITALIZATION h
on p.PF_CODE = h.PF_CODE
group by "入院率", "都道府県コード"
order by "入院率", "都道府県コード" desc;