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