Conditionals in group by

[Hunter Peress]

SELECT sum(if(eventtype='click',1,0)) as
clicks,sum(if(eventtype='view',1,0)) as view from xy group by somethingelse

note the conditional inside the sum. wheres a good source of information on
complex statistical queries like this