SQL |
SELECT DISTINCT subtyp2, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CLOTHING AND FOOTWEAR' and typ='MENS' and subtyp1='Footwear' and upper(subtyp2)<>'EMPTY' and style_id IN (1827,1890,1905,1907,1909,1944,1946,3260,9069,15635,15638,15643,15744,15745,15746,15747,15912,15914,16148,16959,17348,18141,19253,19879,19954,1615)
GROUP BY subtyp2 |