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 (856,2362,3346,3349,3351,4218,4387,4954,4956,4970,4973,4992,4993,8140,8150,8166,11475,11626,14075,16510,16511,16512,16580,16725,16726,16858,16860,16865,16932,16934,16935,16993,16995,16996,17003,17391,17610,17646,17820,17859,18510,18845,18901,19041,19057,19066,19067,19073,19230,19383,19577,19612,19750,19884,19992,20000,20001,20006,20089,20090,20210,20212,20971,20992,21001,21393,21394,21607,21713)
GROUP BY subtyp1 |