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,1835,3529,4846,4847,5221,5249,5307,5313,5316,5535,5563,5564,6240,6316,9400,9593,11311,11313,14678,15433,15637,15729,16659,16660,16836,16870,16872,16959,17623,18027,18175,19253,19297,21089,21112,21123,21236,21354,21359,21361,21592,21594)
GROUP BY subtyp1 |