将一列优先于另一列

卡牌大师

DB提琴
' o5 n5 Q- F- |CREATE TABLE logistics (    id int primary key,   campaign VARCHAR   quantity_offered VARCHAR   quantity_ordered VARCHAR    quantity_delivered VARCHAR   quantity_recorded VARCHAR   quantity_completed VARCHAR(255));INSERT INTO logistics(id,campaign,quantity_offered,quantity_ordered,quantity_delivered,quantity_recorded,quantity_completed)VALUES ("1","C001","500","450","465","462","465"),("2","C002","700","570",NULL,NULL,NULL),("3","C003","600","610","605","602",NULL),("4","C004","300",NULL,NULL,NULL,NULL),("5","C005","400","425",NULL,NULL,NULL),("6","C006","900","870","868",NULL,NULL),("7","C007","350","360","372","375","390"),("8","C008","250","290",NULL,NULL,NULL);在上表中我campaigns不同于它们对应的不同quantities。
的quantities不同的填写方法columns。
现在，我想根据以下层次结构获得每个 最新可用数量campaign：
quantity_completed > quantity_recorded > quantity_delivered > quantity_ordered > quantity_offered结果如下：
: l$ C/ f; d' i- i) W. mCampaign      QuantityC001             46555                C          570005C003          C           30000C5005            42555C            8700C           3900C008             2900002我需要执行什么查询？
% L9 s4 ]. I& l7 X                                                               
    解决方案: