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,6385,6424,6578,6781,6888,6986,7045,7177,7194,7496,7558,7611,7663,7723,7733,7738,7858,7891,10222,10594,11410,14147,15006,15148,15367,15461,15580,16455,17365,17412,17637,17847,18073,18402,18516,18517,18652,18756,18759,959,6362)
GROUP BY subtyp1 |