-- create a table
CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  gender TEXT NOT NULL,
  age INTEGER NOT NULL
);
-- insert some values
INSERT INTO students VALUES (1, 'Ryan', 'M', '24');
INSERT INTO students VALUES (2, 'Joanna', 'F', '27');
INSERT INTO students VALUES (3, 'GEDEON', 'M', '27');
INSERT INTO students VALUES (4, 'AWA', 'F', '30');
-- fetch some values
--SELECT * FROM students WHERE gender = 'F';
SELECT * FROM students WHERE age = '23' AND gender = 'M';