Dijkgraaf - 2:20 am on Sep 19, 2011 (gmt 0)
SELECT dnucity, dnucxtype, count(*) AS cnt
WHERE dnuinstall in ('Retail Pick-up','Tech Install',Direct Fullfill')
GROUP BY dnucity, dnucxtype
I've assumed you still want to limit it to the three types of dnuinstall and dnuoutcome of Accepted.
If not just alter/remove that part of the where clause.