I'm a fairly newbie in SQL.
Spent quiet some time surfing the Web searching for an answer to my problem... which I think is easy to solve for an experienced programmer.
I have a database containing 4 fields in the same table (Customer, Item, Order, DateSold).
The Item field could be either (pant, shirt, blazer, shoe).
Table name: Sales
I would like to have a query that will return only the Customers that have bought >=2 pants AND >=3 shirts in the month (could be bought separately on different order).
And that, for all 2021, (Group by month).