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