SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CAR RACKS' and typ='ROOF RACKS' and upper(subtyp1)<>'EMPTY' and style_id IN (9956,9964,9965,9974,10012,10041,10042,10043,10044,10046,10062,10069,10070,10079,10087,10090,10093,10098,10115,10117,10120,10121,10122,10139,11154,11162,11163,11164,11165,11166,11167,11169,11181,11201,11202,11206,11207,11208,11209,11210,11212,11213,11214,16798,16850,17120)
GROUP BY subtyp1 |