Can you write basic SQL queries for working with databases?

The main SQL queries for working with databases include:

• SELECT — retrieving data from a table.

  SELECT * FROM users WHERE age > 18;
  

• INSERT — adding new records.

  INSERT INTO users (name, age) VALUES ('Ivan', 25);
  

• UPDATE — updating existing records.

  UPDATE users SET age = 26 WHERE name = 'Ivan';
  

• DELETE — deleting records.

  DELETE FROM users WHERE age < 18;
  

• CREATE TABLE — creating a new table.

  CREATE TABLE users (
      id INT PRIMARY KEY,
      name VARCHAR(100),
      age INT
  );
  

• DROP TABLE — deleting a table.

  DROP TABLE users;
  

These queries cover the main CRUD operations (Create, Read, Update, Delete) necessary for working with databases.