IBM Security QRadar

Good day All

I am trying to add another host in my Hostname field to extract 2 hostname for one Domain. Please see Statement below.

SELECT "Hostname" AS 'Hostname (custom)', AVG("Value") AS 'Value (Average)' from events where ( "Metric ID"='EventRate' AND "deviceType"='368' ) AND "Hostname (custom)" = 'host1'
 GROUP BY "Hostname"

I need to extract host2 in the same select...

Any advise?

I have cleaned up my query a bit as well

SELECT "Hostname" AS 'Hostname (custom)', AVG("Value") AS 'Value (Average)' from events where ( "Metric ID"='EventRate' AND "deviceType"='368' AND "Hostname (custom)" = 'host1')
 GROUP BY "Hostname"