Here is what my table looks like

```
ID | Date
------------
13  2013-03-21 00:00:00
13  2013-03-23 00:00:00
13  2013-03-24 00:00:00
25  2013-03-21 00:00:00
25  2013-03-22 00:00:00
25  2013-03-21 00:00:00
25  2013-03-23 00:00:00
25  2013-03-28 00:00:00
25  2013-03-21 00:00:00
82  2013-03-22 00:00:00
82  2013-03-22 00:00:00
I want it to output (combine sat & sun into 'weekend'). It'll combine all the Mondays, Tuesdays, Wednesdays, etc. and combine the values.

day | total
--------------
Friday  2
Thursday 3
Weekend 3

```

This is my query so far

```
SELECT
  CASE
    WHEN DATENAME(weekday, [date]) = 'Saturday' OR DATENAME(weekday, [date]) = 'Sunday' THEN 'Weekend'
    ELSE DATENAME(weekday, [date])
  END AS Day,
  COUNT(DISTINCT [id]) AS score

  FROM [table]

GROUP BY
  CASE
    WHEN DATENAME(weekday, [date]) = 'Saturday' OR DATENAME(weekday, [date]) = 'Sunday' THEN 'Weekend'
    ELSE DATENAME(weekday, [date])
  END

```

Currently I can get my query to output this, but it seems like it isn't adding both thursdays or sat + sun.

```
Day | total
--------------
Friday 2
Thursday 2
Weekend 2

```