SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CLOTHING AND FOOTWEAR' and typ='WOMENS' and upper(subtyp1)<>'EMPTY' and style_id IN (1751,1753,1829,1952,2206,2224,3529,4846,4847,5221,5249,5301,5313,5316,5535,5563,6139,6240,6316,11311,11313,15433,15555,16659,16660,16836,16870,16872,16959,17194,18027,19253,19297,20267,21112,21236,21359,21361)
GROUP BY subtyp1 |