SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CLOTHING AND FOOTWEAR' and typ='KIDS' and upper(subtyp1)<>'EMPTY' and style_id IN (40,1879,1880,3097,3353,3384,3409,5193,5425,5682,5683,9037,9073,10764,10867,10887,10936,11540,13940,14236,14406,14527,15659,15906,16006,16024,16351,16938,17074,17075,17813,17814,17815,17816,17864,17865,17866,18045,18046,18048,18049,18142,18143,18176,18373,18671,18921,18922,19070,19078,19173,1921,1940,8968,10792,10868,10886)
GROUP BY subtyp1 |