I am trying to find customer purchasing pattern from a table.
An order with 'Jacket & Trouser' is considered as 'Suit'
I need to count all orders with Suits and other additional items purchased.
(ignore all order which doesn't have suits i.e 'Jacket and trouser')
Calculation for the above result
1419253 - ignore, no suit combination
1419258 - suit
1419259 - suit + waistcoat
1419266 - suit + waistcoat + tie
There are 20+items can be selected as additional items when purchased, I just showed 'tie and waistcoat' for an example.
How to write a query to do this calculation. Any help will be greatly appreciated.