-- create a table
CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  gender TEXT NOT NULL,
  isEatabble INTEGER DEFAULT 0
);
-- insert some values
INSERT INTO students (name, gender) VALUES ('Ryan 789', 'M');
INSERT INTO students (name, gender) VALUES ('Joanna 789', 'F');
INSERT INTO students (name, gender) VALUES ('Zbysio 789', 'M');
INSERT INTO students (name, gender) VALUES ('Kunegunda 789', 'F');
INSERT INTO students (name, gender, isEatabble) VALUES ('Eugeniusz 789', 'helikopter bojowy', 1);

INSERT INTO students (name, gender) VALUES ('Ryan 123', 'M');
INSERT INTO students (name, gender) VALUES ('Joanna 123', 'F');
INSERT INTO students (name, gender) VALUES ('Zbysio 123', 'M');
INSERT INTO students (name, gender) VALUES ('Kunegunda 123', 'F');
INSERT INTO students (name, gender, isEatabble) VALUES ('Eugeniusz 123', 'helikopter bojowy', 1);

INSERT INTO students (name, gender) VALUES ('Ryan 456', 'M');
INSERT INTO students (name, gender) VALUES ('Joanna 456', 'F');
INSERT INTO students (name, gender) VALUES ('Zbysio 456', 'M');
INSERT INTO students (name, gender) VALUES ('Kunegunda 456', 'F');
INSERT INTO students (name, gender, isEatabble) VALUES ('Eugeniusz 456', 'helikopter bojowy', 1);
-- fetch some values
SELECT * FROM students WHERE name LIKE "Eugeniusz%" OR name LIKE "Kunegunda%" ORDER BY iSEatabble DESC, name;