I have a dataset with multiple columns that look similar to this:
ID1 ID2 ID3 ID4
Blue Grey Fuchsia Green
Black Blue Orange Blue
Green Green Yellow Pink
Pink Yellow NA Orange
select c, count(*) from ( select ID1 as c from tablename union all select ID2 as c from tablename union all select ID3 as c from tablename union all select ID4 as c from tablename ) group by c
HAVING count(*) > 2 at the end to get only Green and Blue.