SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='MORE...' and typ='TRAVEL' and upper(subtyp1)<>'EMPTY' and style_id IN (2094,4097,5062,5074,5075,5140,5169,5170,5183,5209,5476,5477,5616,5617,5678,10000,10053,11359,11360,13988,14237,14589,15794,16651,16652,17268,17269,17766,18718,18780,18791,18792,18948,19913,19914,19915,19916,19917,19918,20137,20161,20162,20163)
GROUP BY subtyp1 |