-- create a table
CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  gender TEXT NOT NULL
  hospital CHARACTER (15) ,  
  commune CHARACTER (20);
-- insert some values
INSERT INTO students VALUES (1, 'Ryan', 'M', 'CésardePape', 'Bruxelles');
INSERT INTO students VALUES (2, 'Joanna', 'F', 'SaintPierre', 'Marolles');
-- fetch some values
SELECT * FROM students WHERE gender = 'F' ;