Where clause

[Michael Landin Hostbaek <mich(at)the-lab(dot)org>]

Hello, 

I have a table called tracking, with a contactid varchar, click bool,
view bool and cid varchar.

I would like to put the following into one single query if possible:

// Number of clicks
select cid,count(distinct contactid) from tracking where click =
true group by cid; 

// Number of views
select cid,count(distinct contactid) from tracking where view =
true group by cid; 

I guess I have to put where (click = true or view = true) - and
differentiate them in the SELECT target.. ?


Many thanks for any input, 

Mike