Dijkgraaf - 3:06 am on Aug 30, 2011 (gmt 0)

Not quite sure what you are aiming for, but you can combine the three as below.

SELECT COUNT(*) FROM sales WHERE dnucxtype='Digital' AND dnuinstall in ('Retail Pick-up','Tech Install',Direct Fullfill') AND dnuoutcome='Accepted';


SELECT COUNT(*) FROM sales WHERE dnucxtype='Analog' AND dnuinstall in ('Retail Pick-up','Tech Install',Direct Fullfill') AND dnuoutcome='Accepted';