-- 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 123', 'M');
INSERT INTO students (name, gender,isEatabble) VALUES ('Joanna 123', 'F',1);
INSERT INTO students (id,name, gender) VALUES (223,'ALEX 123', 'M');
INSERT INTO students (name, gender,isEatabble) VALUES ('Ździsek 123', 'M',1);
INSERT INTO students (name, gender) VALUES ('Test123', 'NaN');

INSERT INTO students (name, gender) VALUES ('Ryan 456', 'M');
INSERT INTO students (name, gender,isEatabble) VALUES ('Joanna 456', 'F',1);
INSERT INTO students (name, gender) VALUES ('ALEX 456', 'M');
INSERT INTO students (name, gender,isEatabble) VALUES ('Ździsek 456', 'M',1);
INSERT INTO students (name, gender) VALUES ('Test456', 'NaN');

INSERT INTO students (name, gender) VALUES ('Ryan 789', 'M');
INSERT INTO students (name, gender,isEatabble) VALUES ('Joanna 789', 'F',1);
INSERT INTO students (name, gender) VALUES ('ALEX 789', 'M');
INSERT INTO students (name, gender,isEatabble) VALUES ('Ździsek 789', 'M',1);
INSERT INTO students (name, gender) VALUES ('Test789', 'NaN');
-- fetch some values
-- SELECT * FROM students;
-- SELECT * FROM students WHERE name LIKE "Ździsek%" OR name LIKE "ALEX%";
-- SELECT * FROM students WHERE name LIKE "%an%" OR name LIKE "% 789";

SELECT * FROM students WHERE name LIKE "%an%" OR name LIKE "% 789" ORDER BY isEatabble DESC, name;
-- DELETE FROM students WHERE gender !="M";


 

-- SELECT * FROM students;
-- SELECT COUNT(*) FROM students;