Assume we’ve got a table named Fruit:
Find the date, fruit and country that with Green and Yellow in color. The result should be like that:
I tried group by still working towards for the expected result. Would you mind giving me some hints / directions? Thanks!