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... Thanks, Richard