SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CAMP AND HIKE' and typ='BACKPACKS AND BAGS' and upper(subtyp1)<>'EMPTY' and style_id IN (5046,5060,5063,5065,5068,5070,5071,5072,5077,5078,5088,5092,5106,5107,5115,5129,5145,5166,5168,5194,5196,5197,14238,14239,14246,14247,14266,14267,14270,14271,14272,14943,16382,18408,18782,18783,18787,18788,18790,18794,19438,19440,19446,19447,19451,19455,19458,19463,19685,20107,20950,20951,20953,20954,20955,21568,21597,21744,21745)
GROUP BY subtyp1 |