-- create a table
CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  gender TEXT NOT NULL,
  age integer not null, 
  box integer not null,
  commmunes text not null   
);
-- insert some values
INSERT INTO students VALUES (1, 'Ryan', 'M',6,1020,'Laeken');
INSERT INTO students VALUES (2, 'Joanna', 'F',8,1190,'Forest');
insert into students values (3,'Sophie','F',10,1030,'Schaerbeek');
insert into students values (4,'Sandrine','F',12,1080,'Molenbeek');
insert into students values (5,'Sandra','F',25,1082'Berchem');
insert into students values (6,'Solange','F',55,1180,'Uccle');
insert into students values (7,'Naomi','F',44,1410,'Waterloo');
insert into students values (8,'Hafida','F',47,1420,'Braine lalleuld');
insert into students values (9,'Marie','F',478,1020'Laeken');
insert into students values (10,'Sévrine','F',66,1020,'Laeken');
insert into students values (11,'Christopher','M',56,1020,'Laeken';
insert into students values (12,'Aaron','M',478,,1020,'Laeken');
insert into students values (13,'David','M',21,1020'Laeken');
insert into students values (14,'Jean-Marc','M',66,1410,'Waterloo');
insert into students values (15,'Cécile','F',55,1410,'Waterloo');
insert into students values (16,'Lynn','F',66,1420,'Braine l Alleud');
insert into studens values (17,'Audrey','F',47,,5000,'Namur');
-- fetch some values
SELECT * FROM students WHERE gender = 'F';
select * from students where gender ='M' ;
select * from students where gender ='F' or gender = 'F';
select * from students ;
select * from students where name ='Sophie';
select * from students where name = 'Solange';
select * from students where name = 'Cécile' ;