DQ Rule for missing values

I would create a SQL Catalog Item based on your table, selecting a count of each colour (including values that aren’t listed), something like the following: 

SELECT Color, COUNT(*) AS Count
FROM ColorsTable
WHERE Color IN ('Black', 'Orange', 'Blue', 'Red')
GROUP BY Color;

Then, build a DQ rule on the SQL Catalog Item, where if the count total is 0, record fails, if greater than 0 record passes. That way, if Red has no records, then Red fails. It would require you to know all the acceptable colours, and list them out specifically like I have in the WHERE clause. 

Not sure if there is a better way, there might be something in Data Aggregation rules that could do this maybe? Nothing I’m familiar with though. 

Thanks ​@bobparry for your suggestion.  I was thinking different way.  

Create Aggregated rule like Maximum (find (‘RED’, <Attribute>), this way, you can if you find the RED anywhere in column values, it will true value. Maximum will return true. If RED doesn't available, all the values will be false. Hence it will return false. 

But I am looking for any better approach where we can provide the list of value to find the same without creating additional catalog items.

Should there be an option to calculate such thing by creating SQL statement under DQ rule section, instead of creating new catalog item for each scenario.