SQL |
SELECT DISTINCT subtyp2, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CLOTHING AND FOOTWEAR' and typ='MENS' and subtyp1='Accessories' and upper(subtyp2)<>'EMPTY' and style_id IN (5221,5225,5235,5236,5249,5269,5270,5279,5298,5299,5300,5301,5302,5304,5309,5313,5316,13959,13961,14099,14101,16121,16122,16125,17194,17199,17680,18188,18192,19497,20261,20262,20267,20373,20374,20376,20378,20382)
GROUP BY subtyp2 |