What types of database queries have you implemented in your projects?

In projects, I implemented various types of database queries, including:

• SELECT — for retrieving data with different conditions (filtering, sorting, aggregation).
• INSERT — for adding new records.
• UPDATE — for modifying existing data.
• DELETE — for deleting records.
• Queries with JOIN to combine data from multiple tables.
• Using subqueries and aggregate functions (SUM, COUNT, AVG).

Example of a simple SELECT query with a condition:

SELECT id, name, email FROM users WHERE status = 'active' ORDER BY created_at DESC;