Hi
My query returns all the records of "active" London customers who have ordered within the past year. I also need to know how many customers, but where do I put the COUNT function?
SELECT *, MAX(customers_orders.date) AS maxdate,
customers.id AS refid,
FROM customers
LEFT JOIN...