i have following table:
| id | product | type | data_start | +----+---------+------+------------+ | 3 | phone | voip | 2015-07-01 | | 5 | phone | voip | 2012-03-02 | | 6 | phone | voip | 2015-07-04 | | 7 | phone | voip | 2012-03-05 | | 8 | phone | voip | 2012-03-05 | | 8 | phone | voip | 2012-03-06 | | 8 | phone | voip | 2012-03-06 | i need genenerate report of 7 days sold in past, although day 03.07.2015 , 07.09.2015 day did not sell me bring 0.
| day | count | +-----+-------+ | 1 | 1 | | 2 | 1 | | 3 | 0 | | 4 | 1 | | 5 | 2 | | 6 | 2 | | 7 | 0 | they know how can case? 2 dates not system, mentioned report last 7 days want know day not sold
Comments
Post a Comment