Is there a way to insert an 'OR' condition in a 'Group by' statement?

[MEBG93]

Hello!

I was wondering if there is a way to insert an 'OR' statement in a 'Group by' statement.

E.g.

load * inline [

name, location, team

a, london, red

b, london, green

c, manchester, red

d, london, blue]

group by

team = 'red'

or

team='blue';

Thanks!

[naumanshah]

'Group by' is typically used in conjunction with aggregation functions like SUM/AVG etc. When you are using load * inline then you don't need to group by the data.

[sunny_talwar]

What output are you looking to see?