In SQL, the logical operators `AND`, `OR`, and `NOT` are used to combine conditions in queries. Here's a brief explanation of how they work:

- `AND`: The `AND` operator is used to combine two or more conditions, and it returns true if all the conditions evaluate to true. For example:

sql
SELECT * FROM table_name WHERE condition1 AND condition2;

This query will select rows from `table_name` that satisfy both `condition1` and `condition2`.

- `OR`: The `OR` operator is used to combine two or more conditions, and it returns true if at least one of the conditions evaluates to true. For example:

sql
SELECT * FROM table_name WHERE condition1 OR condition2;

This query will select rows from `table_name` that satisfy either `condition1` or `condition2`.

- `NOT`: The `NOT` operator is used to negate a condition and returns the opposite result. It reverses the boolean value of the condition. For example:

sql
SELECT * FROM table_name WHERE NOT condition;

This query will select rows from `table_name` that do not satisfy the given `condition`.

You can use parentheses to control the order of evaluation when combining multiple conditions. This is especially important when mixing `AND` and `OR` operators to ensure the desired logic is achieved.

Here's an example to illustrate the usage of `AND`, `OR`, and `NOT` together:

sql
SELECT * FROM table_name WHERE (condition1 AND condition2) OR NOT condition3;

This query will select rows from `table_name` that satisfy both `condition1` and `condition2`, or rows that do not satisfy `condition3`.

Keep in mind that the specific syntax and usage of these operators may vary depending on the SQL database system you are working with.