SQL |
SELECT DISTINCT subtyp2, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='MORE...' and typ='PUBLICATIONS' and subtyp1='Maps' and upper(subtyp2)<>'EMPTY' and style_id IN (199,200,206,472,473,474,3792,3867,4543,4591,4642,9489,13963,13969,15220,16038,16040,17255,18084,18085,18086,18087,19026,19029,19779,19781,19782,19785,19786,475,4088)
GROUP BY subtyp2 |