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.