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 (1306,1308,1318,1319,1341,1368,1383,1422,1425,1427,1429,1430,11269,11278,16611,16616,16618,17671,17678,18962,18964,19921,20368,20904,20905,20906,20958,20959,20960,20961,20962,20963,20964,20965,20966,20967,20968,20969)
GROUP BY subtyp1 |