-- create a table
CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  gender TEXT NOT NULL,
  date_birth text not null  
);
-- insert some values
INSERT INTO students VALUES (1, 'Ryan', 'M','28/04/1968');
INSERT INTO students VALUES (2, 'Joanna', 'F','31/03/1970');
insert into students values (3,'Eric',' M','27/10/1973');
insert into students values (4,'Rudy','M','10/06/1972');
insert into students values (5,'Sophie','F','25/09/1947');
-- fetch some values
SELECT * FROM students WHERE gender = 'F';
select * from students where gender = 'M' ;
select * from students where gender = 'F' or gender = 'M' ; 
select * from students where gender = 'F' and not gender = 'M';