SQL |
SELECT DISTINCT subtyp2, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CLOTHING AND FOOTWEAR' and typ='WOMENS' and subtyp1='Outerwear' and upper(subtyp2)<>'EMPTY' and style_id IN (350,1792,2171,3522,3531,3622,5331,5334,5446,5455,5594,5637,5638,5726,5728,5732,5737,5745,9594,9721,9890,9927,9931,11297,14067,14333,14517,14522,15086,15088,15122,15417,15418,15509,16669,16723,16806,16809,16880,16881,16929,17282,17286,17472,17625,17626,17629,17849,17915,17917,17944,17968,17969,18262,18287,18413)
GROUP BY subtyp2 |