将一列优先于另一列

用途

coalesce()

select campaign, coalesce(quantity_completed, quantity_recorded, quantity_delivered, quantity_ordered, quantity_offered) as quantityfrom logistics;