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 (1831,1859,1890,1905,1907,1944,14734,14738,15196,15638,15643,15743,15746,15747,15749,15914,16787,16959,17349,19253,19875,19879,20134,20268,21647,1615)
GROUP BY subtyp2 |