I need help defining a piece of SQL that would achieve the following...
Basically I want it to work like this
Case when products = 'Coats' then 'Coats' else 'No Coats'
when product = 'Jackets' then 'Jackets' else 'No Jackets'
when product = 'Hats' then 'Hats' else 'No Hats'
So if there was only coats the list would be
or if there are coats & hats it would read