Why Q1 not correct? Because it is fetching any red part and not every red part,right??
Why Q2 is not correct query? It takes 2 tables and comparing. Is it not fetching single red value?
chk this example
If we consider these two tables
According to question, we should return S3
but Q1 returning S1, S2, S3
and Q2 returning nothing