dennis.sprengers@gmail.com wrote:

> I want to count the number of hits and sessions in the past week, so I
> wrote:
>
> SELECT `date`, SUM(hits), SUM(sessions)
> FROM stats_dt
> WHERE YEARWEEK(`date`) = YEARWEEK(CURDATE())
> GROUP BY `date` DESC
>
> The resultset looks like:
>
> +------------+---------------+-----------+
> | date | SUM(sessions) | SUM(hits) |
> +------------+---------------+-----------+
> | 2007-10-22 | 6 | 172 |
> +------------+---------------+-----------+
> | 2007-10-23 | 6 | 210 |
> +------------+---------------+-----------+
> | 2007-10-24 | 12 | 118 |
> +------------+---------------+-----------+
> | 2007-10-25 | 2 | 37 |
> +------------+---------------+-----------+
>
> As expected, but not entirely what I want: I want to get the SUM of
> all hits and sessions, like this:
>
> +----------+------+
> | sessions | hits |
> +----------+------+
> | 26 | 537 |
> +----------+------+

Don't group


--

//Aho