SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CAMP AND HIKE' and typ='SLEEP GEAR' and upper(subtyp1)<>'EMPTY' and style_id IN (4733,4736,4739,4740,4741,4743,4744,4752,4753,4760,4761,4762,4764,4767,4768,4769,4771,14003,14790,15477,15478,15479,16710,16722,18997,20114)
GROUP BY subtyp1 |