SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CAMP AND HIKE' and typ='TENTS AND HAMMOCKS' and upper(subtyp1)<>'EMPTY' and style_id IN (553,573,574,592,594,600,601,614,615,1442,1478,1529,2098,2099,2100,2103,2105,2106,2107,2108,2111,2112,2113,2114,2115,2116,2746,3779,3780,4099,4160,4475,4717,4722,4763,4772,9523,9538,9682,9683,9881,11349,11350,14545,14593,14791,16501,16502,16703,16704,16705,16720,17371,17372,17589,18410,18904)
GROUP BY subtyp1 |