SQL |
SELECT DISTINCT subtyp2, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CLOTHING AND FOOTWEAR' and typ='WOMENS' and subtyp1='Skirts and Dresses' and upper(subtyp2)<>'EMPTY' and style_id IN (1422,1746,1755,2902,2990,2998,3002,3598,5462,8005,11308,14487,16410,16431,16443,16610,16611,16614,16619,16684,16837,16869,17676,17677,17952,17953,18960,18961,19033,19166,19168,19210,19215,19218,19295,19367,19415,19426)
GROUP BY subtyp2 |