SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CLOTHING AND FOOTWEAR' and typ='WOMENS' and upper(subtyp1)<>'EMPTY' and style_id IN (9568,9593,9783,9858,9899,9927,9931,15079,15090,16806,16807,16808,16817,16933,16936,16939,16947,16948,17284,17620,17621,17623,17625,18956,18985,18987,18988,19127,19129,19130,19152,19256,19352,19353,19363,19366,19367,19858,20051,20059,20393,20493,20500,20501,20934,20986,9913)
GROUP BY subtyp1 |