I am trying to query several different colors from one column. This is what I have so far:
=query('Raw Data'!C1:J1000, "Select E, D, I, J, C, F, H where H contains 'Monday' and F='Green' and C='schools' order by E")
For example I want to query all the items that are Green, Red, and Blue in the F column. Is there a way to query for multiple selection in 1 column?