`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,
  sum(case `order`.order_status when 'delivery-approved' then 1 else 0 end) deliveryapproved
FROM order_customFields
  INNER JOIN `order` ON order_customFields.order_id = `order`.order_id
WHERE
  order_customFields.order_customFields_order_date >= date_sub(date_sub(curdate(), interval day(curdate()) - 1 day), interval 1 month) and
      order_customFields.order_customFields_order_date < date_sub(curdate(), interval day(curdate()) - 1 day)
AND order_customFields.order_customFields_delivery_method is not null
GROUP BY
   order_customFields.order_customFields_delivery_method`

`SELECT order_customFields.order_customFields_delivery_method,
sum(round(`order`.order_totalSumm,2))
FROM order_customFields
  INNER JOIN `order` ON order_customFields.order_id = `order`.order_id
WHERE
  order_customFields.order_customFields_order_date >= date_sub(date_sub(curdate(), interval day(curdate()) - 1 day), interval 1 month) and
      order_customFields.order_customFields_order_date < date_sub(curdate(), interval day(curdate()) - 1 day)
and order_status = 'paid' or order_status = 'later' or order_status = 'delivery-approved'
AND order_customFields.order_customFields_delivery_method is not null
GROUP BY
   order_customFields.order_customFields_delivery_method`