CREATE TABLE `students`
(
    `id`   INTEGER PRIMARY KEY AUTO_INCREMENT,
    `name` TEXT    NOT NULL,
    `age`  INTEGER NOT NULL
);

-- добавление

INSERT INTO `students`
    (`name`, `age`)
VALUES
    ('Anna',   15),
    ('Ryan',   16), ('Joanna', 16), ('Danil', 16),
    ('Johan',  17),
    ('Petia',  18),
    ('Slava',  19),
    ('Osipov', 21),
    ('Nastya', 22),
    ('Igor',   23), ('Polina', 23), ('Katia', 23),
    ('Rislan', 24), ('Liza',   24), ('Dasha', 24),
    ('Adam',   25), ('Maksim', 25), ('Ivan',  25), ('Egor',   25), ('Pavel',  25),
    ('Lev',    26), ('Kirill', 26), ('Vadim', 26), ('Victor', 26), ('Leonid', 26);

-- удаление
-- DELETE FROM `students` WHERE `age` IN (16, 25, 26);

-- выборка
-- SELECT * FROM `students` WHERE `age` = 23;

-- сортировки
SELECT * FROM `students` ORDER BY `name` ASC;

-- SELECT * FROM `students`;

Embed on website

To embed this project on your website, copy the following code and paste it into your website's HTML: