details by supplier

SELECT
  spree_orders.number,
  date_trunc('day', spree_orders.completed_at at time zone 'utc' at time zone 'edt') as date,
  total - additional_tax_total                                                       as revenue,
  cost_total                                                                         as items_cost,
  COALESCE(SUM(shipping_cost), 0)                                                    as shipping_cost,
  ARRAY_AGG(DISTINCT spree_suppliers.name) as suppliers
FROM "spree_orders"
  LEFT JOIN "supplier_orders" ON "supplier_orders"."spree_order_id" = "spree_orders"."id"
  LEFT JOIN "supplier_shipments" ON "supplier_shipments"."order_id" = "supplier_orders"."id"
  LEFT JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "supplier_shipments"."spree_stock_location_id"
  LEFT JOIN "spree_suppliers" ON "spree_suppliers"."id" = "spree_stock_locations"."supplier_id"
WHERE "spree_orders"."completed_at" IS NOT NULL
  AND "spree_orders"."completed_at" >= '2019-09-01 05:00:00'
GROUP BY spree_orders.id