I get the number of orders by shipping_arrival_date with the following query:
SELECT COUNT(*) as orders_on_day, shipping_arrival_dateenter preformatted text here FROM sales_flat_order group by shipping_arrival_date order by shipping_arrival_date asc
How can I modify this query in a way that it shows me a third column with the number of first time customers on this particular shipping date?
I know that within sales_flat_order there is the
customer_id which matches with the
customer_entity, but I somehow need to know if the customer has ordered before.
Does anybody can help here?