SQL |
SELECT DISTINCT subtyp2, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CLOTHING AND FOOTWEAR' and typ='MENS' and subtyp1='Outerwear' and upper(subtyp2)<>'EMPTY' and style_id IN (329,353,355,2174,3520,5330,5439,5512,5598,5640,5644,5645,5731,5777,8517,9597,9598,9670,9827,9849,9949,15422,15573,16107,16813,16982,17473)
GROUP BY subtyp2 |