What SQL operators do you use, and how often?

Main SQL operators I use regularly:

• SELECT — for retrieving data from tables.
• INSERT — for adding new records.
• UPDATE — for modifying existing data.
• DELETE — for deleting records.
• JOIN (INNER, LEFT, RIGHT) — for combining tables based on keys.
• WHERE — for filtering data based on conditions.
• GROUP BY and HAVING — for grouping and filtering aggregated data.
• ORDER BY — for sorting results.

Frequency of use depends on the task, but SELECT and WHERE are the most common, as almost always data needs to be retrieved and filtered. INSERT and UPDATE are used when working with data modifications. JOIN is used when working with multiple related tables.

Example of a simple query:

SELECT users.name, orders.amount
FROM users
JOIN orders ON users.id = orders.user_id
WHERE orders.amount > 100
ORDER BY orders.amount DESC;