-- create a table
CREATE TABLE CLIENTS (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  gender TEXT NOT NULL
  work TEXT NOT NULL
);
-- insert some values
INSERT INTO students VALUES (1, 'Ryanbis',  'M', 'aviateur');
INSERT INTO students VALUES (2, 'Ryan', 'M' , 'bishop');
INSERT INTO students VALUES (3, 'Joanna', 'F' , 'stomathérapeute');
INSERT INTO students VALUES (4, 'Carine', 'F', 'nurse');
INSERT INTO students VALUES (5, 'Solange', 'F' , 'secrétaire');
INSERT INTO students VALUES (6, 'Johanna','F' , 'assistant');
INSERT INTO students VALUES (7, 'John', 'M' , 'retraité');
-- fetch some values
SELECT * FROM students WHERE gender = 'F';