SELECT customer_email, customer_firstname, customer_lastname, SUM(subtotal_invoiced) AS t
Min(created_at) as d,
Count (*) as num

FROM sales_flat_order AS a

GROUP BY customer_email ORDER BY t DESC