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,9976,10012,10041,10042,10043,10044,10046,10062,10070,10074,10079,10087,10090,10093,10098,10115,10117,10120,10121,10122,10139,16850,17382,17525)
GROUP BY subtyp1 |