What types of SQL queries have you used in your projects?

In projects, I used the following types of SQL queries:

• SELECT — for retrieving data from tables with various conditions, sorting, and joins.
• INSERT — for adding new records to tables.
• UPDATE — for modifying existing data based on specified conditions.
• DELETE — for removing records from tables.
• JOIN — for combining data from multiple tables.
• CREATE TABLE and ALTER TABLE — for creating and modifying the database structure.

Example of a simple SELECT query:

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