Hi SQL Guru's





Please help me.



I need to use a single query to get the following results sets:



AgeBracket JWBlack
JWRed

Unknown Age 18
3

<18 2
9

18-24 9
11

25-30 0
45

31-44 49
7

45-49 78
9

50+ 4
9



This specify the count of consumers per age group. JWBlack and JWRed is
group by filters.





Thanks



Chris Beukes

DBA

Global Vision




MS Sql Server LazyDBA home page