-- create a table
CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  gender TEXT NOT NULL , 
  WORKS CHAR (10),
  TOWN CHAR (15) 
    );
-- insert some values
INSERT INTO students VALUES (1, 'Ryan', 'M', 'maçon','Schaerbeek');
INSERT INTO students VALUES (2, 'Joanna', 'F','infimière', 'Bruxelles');
INSERT INTO students VALUES  (3,'Carine', 'F','infirmière', 'Laeken');
INSERT INTO students VALUES (4, 'Solange', 'F','secrétaire', 'Bruxelles');
INSERT INTO students VALUES (5, 'Sophie', 'F', 'urgentiste','Bruxelles');
INSERT INTO students VALUES ( 6, 'Chantal', 'F','chef','Sainte');
INSERT INTO students VALUES ( 7, 'Dernier', 'M','docteur','Malines');

-- fetch some values
SELECT * FROM students WHERE gender = 'F' or gender = 'M';