每月新客户列表

Question

Month
[e-mail]
[e-mail]
[e-mail]

如果做起来不太复杂，按月将它们分组也会有效。意思是...

2011年新客户

Jan      Feb      Mar
email1   email4   email7
email2   email5   email8
email3   email6   email9

...诸如此类。我可能更喜欢更简单的一次只显示一个月，虽然，为了我能够尝试和理解，哈哈。

null

编辑：如果它有帮助，我以前被给了这个人造代码来工作，但它超出了我的能力。/哑巴

SELECT <customer info> 
FROM <customer table> 
WHERE (SELECT COUNT(<order info>) 
    FROM <order table> 
    WHERE <customer info> = <current customer> 
        AND <date> < <target date>) = 0 
        AND (SELECT COUNT(<order info> 
            FROM <order table> 
            WHERE <customer info> = <current customer> 
            AND <date> > <target date>) > 0

Answer 1

下面的查询为您获取每个客户的首次订单日期：

select email, min(orderdate) as FirstOrderDate
from orders o
group by email;

要获得按月份计算的新客户数：

select year(FirstOrderDate) as yr, month(FirstOrderDate) as mon, count(*)
from (select email, min(orderdate) as FirstOrderDate
      from orders o
      group by email
     ) oc
group by year(FirstOrderDate), month(FirstOrderDate);

获取给定月份的客户：

select email
from (select email, min(orderdate) as FirstOrderDate
      from orders o
      group by email
     ) oc
where FirstOrderDate >= '2013-01-01' and
      FirstOrderDate < '2013-02-01'