SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CLOTHING AND FOOTWEAR' and typ='MENS' and upper(subtyp1)<>'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,16120,16121,16122,16125,17194,17199,17348,17349,17680,18188,18190,18192,19497,20261,20262,20267,20268,20373,20374,20376,20378,20382)
GROUP BY subtyp1 |