SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CAMP AND HIKE' and typ='KNIVES, TOOLS AND GEAR' and upper(subtyp1)<>'EMPTY' and style_id IN (706,752,881,886,897,899,906,2367,2369,2374,2375,2382,2386,2387,2388,2391,2393,2394,2763,3122,3734,3735,3736,3739,3746,3814,3891,3943,4013,4041,4056,4057,4135,5921,5927,5930,5931,5932,8393,13917,13972,14026,15250,15317,15340,15400,15612,15652,15670,15677,15867,15868,15870,15872,15873,15965,16191,16193,16194,16197,16198,16334,16692,17029,17119,17139,17217,17249,17469,18357,18446,18447,18448,18449,18474,19488,19490,19491,19710,19736)
GROUP BY subtyp1 |