SQL Help - New Customers

[chetwyn]

HI Guys.. been banging my head against the wall.

 

I'm trying to run a query to find:

• how many new customers per week
  
• how many return customers order per week
  

 

please help totally stuck aaahhhhh!!!

[PhiLho]

Not sure if MySQL allows you to do such stats, but an element of answer is:

SELECT COUNT(*) FROM ps_customer WHERE date_add >= DATE_ADD(NOW(), INTERVAL -1 WEEK);

to see how many customers created an account in the last week.

 

Not sure how you qualify "return customers order".

[bellini13]

perhaps factor the customer create date in relation to the order date