-- create a table
CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  gender TEXT NOT NULL , 
  WORKS CHAR (15)  ,
  TOWN CHAR (20),
  AREA CHAR (20)  );
-- insert some values
INSERT INTO students VALUES (1, 'Ryan', 'M', 'docteur', 'Bruxelles','02');
INSERT INTO students VALUES (2, 'Joanna', 'F','infirmière','Laeken','02');
INSERT INTO students VALUES (3, 'Beyoncé', 'F','singer','Washington','301');
INSERT INTO students VALUES (4,'Rihana', 'F','singer','NewYorkCity', '701');

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