SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CLOTHING AND FOOTWEAR' and typ='KIDS' and upper(subtyp1)<>'EMPTY' and style_id IN (40,1879,1880,2008,3097,3353,3409,5193,5682,5683,8984,8999,9000,9037,9068,9073,10936,13940,14236,14405,14406,14527,15659,15906,16006,16351,17074,17075,1921,1940,8968)
GROUP BY subtyp1 |