-- 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, 'Alain','F');
insert into students values (4,'Enriko','M');
insert  into students values (5,'Erika','F');
insert into students values (6,'Louis','M');
insert into students values (7,'Stéphane','M');
insert into students values (8,'Loé','M');
insert into students values (9,'Corine','F');
insert  into students values (10,'Adeline','F');
-- fetch some values
-- SELECT * FROM students
SELECT * FROM students WHERE id = 3 or id= 5 ;
select * from  students where id =10  or gender ='F' and not gender ='M';
select * from students where gender = 'M'  ;
select * from students where gender = 'M' or gender = 'F';