I'm trying to create custom column in google sheets with query function.

for instance (in order to be simple) - I have this data.

and the result should look like this, if Revenue is more than 500 000 - Good and if not Bad:

is this possible to do this with query? I would appreciate you help.

=QUERY(A1:B4,"select *")

here is the link