Untitled

SELECT dnuinstall, COUNT(*)FROM sales WHERE (dnucxtype=&#039;Digital&#039; AND dnuinstall in (&#039;Retail Pick-up&#039;,&#039;Tech Install&#039;,&#039;Direct Fullfill&#039;) AND dnuoutcome=&#039;Accepted&#039;GROUP BY dnuinstall) and (dnucxtype=&#039;Analog&#039; AND dnuinstall in (&#039;Retail Pick-up&#039;,&#039;Tech Install&#039;,&#039;Direct Fullfill&#039;) AND dnuoutcome=&#039;Accepted&#039;GROUP BY dnuinstall);