mysql - 查询中的列总和

Question

我有这个问题

`SELECT order_customFields.order_customFields_delivery_method,

    sum(case `order`.order_status when 'paid' then 1 else 0 end) paid,
    sum(case `order`.order_status when 'later' then 1 else 0 end) later
FROM order_customFields 
  INNER JOIN `order` ON order_customFields.order_id = `order`.order_id

where `order`.order_createdAt >= date_sub(date_sub(curdate(), interval day(curdate()) - 1 day), interval 1 month) 
and `order`.order_createdAt < date_sub(curdate(), interval day(curdate()) - 1 day)
AND order_customFields.order_customFields_delivery_method in('a','b','c','d','e')
GROUP BY    
   order_customFields.order_customFields_delivery_method`

如何在此查询中获取列 paid 和 later 的总和？像这样example

Answer 1

如果你想求两列之和，只需使用IN

sum(case when `order`.order_status in ('paid', 'later') then 1 end)