select
    h.PF_CODE as 都道府県コード,
    p.PF_NAME as 都道府県名,
    (case
    when (INP_YES * 100) % (INP_YES + INP_NO + UNIDENTIFIED) = 0
    then
      format("%d", (INP_YES * 100) / (INP_YES + INP_NO + UNIDENTIFIED))
    else
      format("%.2f", 100.0 * INP_YES / (INP_YES + INP_NO + UNIDENTIFIED)) 
    end) as 入院率
from
    HOSPITALIZATION as h
    left join PREFECTURE as p on h.PF_CODE = p.PF_CODE
order by
    入院率 desc,
    都道府県コード asc;