---

SELECT sqlite_version();

CREATE TABLE students (
    id         INTEGER PRIMARY KEY AUTOINCREMENT,
    first_name TEXT    NOT NULL,
    last_name  TEXT    NOT NULL,
    age        INTEGER,
    email      TEXT    UNIQUE
);

ALTER TABLE students RENAME TO students_new;

ALTER TABLE students_new RENAME COLUMN first_name TO name;

ALTER TABLE students_new ADD COLUMN phone TEXT;

INSERT INTO students_new (name, last_name, age, email)
VALUES ('Иван', 'Иванов', 20, 'ivan@example.com');

UPDATE students_new
SET phone = '+7-900-111-22-33'
WHERE name = 'Иван' AND last_name = 'Иванов';

SELECT * FROM students_new;

DROP TABLE students_new;