SQL |
SELECT DISTINCT subtyp2, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CAMP AND HIKE' and typ='KNIVES, TOOLS AND GEAR' and subtyp1='Trekking Poles' and upper(subtyp2)<>'EMPTY' and style_id IN (706,752,3695,3701,3709,3722,3735,3736,3739,3742,3746,3881,4041,14856,15317,15612,15677,16691,16692,16693,18357,18446,18447,18448,18450)
GROUP BY subtyp2 |