SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CLOTHING AND FOOTWEAR' and typ='MENS' and upper(subtyp1)<>'EMPTY' and style_id IN (9518,9544,9575,9598,9626,9784,9837,9849,9915,15135,16813,16822,16932,16934,16935,16949,16951,18947,18951,18954,18955,18978,18980,19255,19349,19353,19354,19355,19860,19861,20052,20053,20054,20185,20186,20188,20339,20495,20498,20902,20934,21020,21021)
GROUP BY subtyp1 |