On Fri, Apr 19, 2013 at 8:24 AM, Richard Reina <gatorre...@gmail.com> wrote: > Hello All, > > Happy Friday! I know how to do the following query: > >>select count(*) from sales where WEEK(sale_date)=15 AND > YEAR(sale_date)=2013; > > But can someone tell me I can do a query that will give me: > > the count(*) for each week of 2013 so that I end up with: > > WEEK | COUNT > 1 | 22 > 2 | 31 > 3 | 29 > etc...
select WEEK(sale_date), count(*) from sales where YEAR(sale_date)=2013 group by WEEK(sale_date); -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql