Can you list the main types of SQL operators and explain their purpose?

The main types of operators in SQL include:

• Arithmetic operators: used for performing mathematical operations, such as +, -, *, /.
• Comparison operators: allow comparing values, such as =, <> (not equal), <, >, <=, >=.
• Logical operators: used to combine conditions, such as AND, OR, NOT.
• Assignment operators: used in some DBMSs to update values, such as :=.
• LIKE and BETWEEN operators: for pattern matching (LIKE) and range checking (BETWEEN).

Example of using operators:

SELECT * FROM employees
WHERE salary > 50000 AND department = 'IT';