---

--1
CREATE TABLE Pilots
(
  id INT GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
  pilot_name TEXT NOT NULL,
  experience INT
);

--2
INSERT INTO Pilots (pilot_name, experience)
VALUES ('Иван', 5),
('Петр', 2),
('Павел', 7),
('Борис', 1);

--3
ALTER TABLE Pilots
ADD COLUMN phone VARCHAR(12) NOT NULL DEFAULT '';

UPDATE Pilots SET phone = '+70000000000' WHERE pilot_name = 'Иван';
UPDATE Pilots SET phone = '+70000000001' WHERE pilot_name = 'Петр';
UPDATE Pilots SET phone = '+70000000002' WHERE pilot_name = 'Павел';
UPDATE Pilots SET phone = '+70000000003' WHERE pilot_name = 'Борис';

ALTER TABLE Pilots
ALTER COLUMN phone DROP DEFAULT;