SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CYCLING' and typ='BIKE TOOLS' and upper(subtyp1)<>'EMPTY' and style_id IN (961,1087,2509,6424,6578,6648,6780,6781,6888,6986,7045,7177,7194,7558,7611,7663,7723,7738,7858,10222,10594,11410,14147,15148,15367,15461,15580,17412,17637,17920,18073,18402,18756,18759,19206,19228,19370,19371,959,6362)
GROUP BY subtyp1 |