-- create a table
CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  name CHARACTER (10) ,
  gender CHARACTER (1),
  working CHARACTER (20),
  town CHARACTER (15), 
  code_postal CHARACTER (4) );
-- insert some values
INSERT INTO students VALUES (1, 'Ryanbis',  'M', 'aviateur','Forest', '1190');
INSERT INTO students VALUES (2, 'Ryan', 'M' , 'bishop' , 'Woluwé','1200');
INSERT INTO students VALUES (3, 'Joanna', 'F' , 'stomathérapeute', 'Saint_Josse', '1210');
INSERT INTO students VALUES (4, 'Carine', 'F', 'nurse', 'Laeken','1020');
INSERT INTO students VALUES (5, 'Solange', 'F' , 'secrétaire','Schaerbeek' , '1030');
INSERT INTO students VALUES (6, 'Johanna','F' , 'assistant', 'Uccle','1180');
INSERT INTO students VALUES (7, 'John', 'M' , 'retraité' , 'Etterbeek', '1040');
-- fetch some values
SELECT * FROM students WHERE gender ='M';