-- create a table
CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  gender TEXT NOT NULL
);
-- insert some values
INSERT INTO students VALUES (1, 'Ryan', 'M');
INSERT INTO students VALUES (2, 'Joanna', 'F');
insert into students values (3,'Eric','M');
insert into students values (4,'Sophie','F');
insert into students values (5,'Andréa','F');
insert into students values (6,'Aaron','M');
insert into students values (7,' Joséphine','F');
insert into students values (8,'Alain','M');
insert into students values (9,'Nadine','F');
insert into students values (10,'Sandrine','F');
insert into students values (11,'Joséphine','F');
insert into students values (12,'Jos','M');
-- fetch some values
SELECT * FROM students WHERE gender = 'F';
select * from students where gender = 'M';
select * from students where gender = 'M' and not gender = 'F';
select * from students where gender = 'F' and not gender = 'M';
select * from students where gender = 'F' or gender = 'M';