# Logical Operators and Conditional and Subquery Expressions

## Logical Operator Support

| Operator | Description   |
| -------- | ------------- |
| `AND`    | Logical AND   |
| `NOT`    | Negates value |
| `OR`     | Logical OR    |

## Conditional Expression Support

| Expression                                         | Description                                  |
| -------------------------------------------------- | -------------------------------------------- |
| `CASE WHEN condition THEN result ELSE default END` | Case operator                                |
| `COALESCE(val1, val2, ..)`                         | Returns the first non-null value in the list |

{% hint style="info" %}
Geospatial and array column projections are not supported in the `COALESCE` function and CASE expressions.
{% endhint %}

## Subquery Expression Support

| Expression                                 | Description                                                     |
| ------------------------------------------ | --------------------------------------------------------------- |
| `expr IN (subquery or list of values)`     | Evaluates whether expr equals any value of the IN list.         |
| `expr NOT IN (subquery or list of values)` | Evaluates whether expr does not equal any value of the IN list. |

#### Usage Notes

* You can use a subquery anywhere an expression can be used, subject to any runtime constraints of that expression. For example, a subquery in a CASE statement must return exactly one row, but a subquery can return multiple values to an IN expression.
* You can use a subquery anywhere a table is allowed (for example, `FROM` subquery), using aliases to name any reference to the table and columns returned by the subquery.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.heavy.ai/v8.3.0/sql/data-manipulation-dml/sql-capabilities/logical-operators-and-conditional-and-subquery-expressions.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.