-- create a table
CREATE TABLE Airline (
pilot id INTEGER PRIMARY KEY,
 name TEXT NOT NULL,
  plane number INTEGER NOT NULL 
);
-- insert some values
INSERT INTO Airline VALUES (1236, 'Ryan', '13967');
INSERT INTO Airline VALUES (2645, 'Juli', '238947');
INSERT INTO Airline VALUES (3476 , 'Robin','547954');
INSERT INTO Airline VALUES (4567 , 'Ben',   '66767');
-- fetch some values
SELECT * FROM Airline WHERE plane = '13967';