serializer
Programmer
I have an order table with customer id and tradedate. I would like to get statistics about number of new customers for each month. I defined a new customer by an order row with a customerid I have not counted before. I am not sure if this is possible through SQL only.
Here is my sample query:
select customerid,tradedate from [order] where paid = 1
Basically I would like a result like this:
201301 5
201302 4
201303 6
etc
Thank you!
Here is my sample query:
select customerid,tradedate from [order] where paid = 1
Basically I would like a result like this:
201301 5
201302 4
201303 6
etc
Thank you!