Hi All !!! I have the following table:
I need a query that will output the SKU:
(1) Instances where red is the only color.
(2) If there are multiple colours, it will exclude red.
The output would be as follows:
I'm not quite sure how to do this, Any ideas? thanKS!
SELECT SKU, PRODUCT_COLOR FROM TABLE T1