What queries are included in the CRUD group of SQL language?

CRUD — these are the basic data operations corresponding to four types of SQL queries:

• Create — INSERT — adding new records to a table.
• Read — SELECT — retrieving data from a table.
• Update — UPDATE — modifying existing records.
• Delete — DELETE — removing records from a table.

Example:

-- Create
INSERT INTO users (name, age) VALUES ('Ivan', 30);

-- Read
SELECT * FROM users WHERE age > 25;

-- Update
UPDATE users SET age = 31 WHERE name = 'Ivan';

-- Delete
DELETE FROM users WHERE name = 'Ivan';