List:General Discussion« Previous MessageNext Message »
From:Larry Martell Date:April 19 2013 2:40pm
Subject:Re: Query Help
View as plain text  
On Fri, Apr 19, 2013 at 8:24 AM, Richard Reina <gatorreina@stripped> 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);
Thread
Query HelpRichard Reina19 Apr
  • RE: Query HelpIlya Kazakevich19 Apr
  • Re: Query HelpLarry Martell19 Apr
    • Re: Query HelpRichard Reina19 Apr