-- create a table
CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  gender TEXT NOT NULL,
    town TEXT NOT NULL
);
-- insert some values
INSERT INTO students VALUES (1, 'Ryan', 'M','Schaerbeek');
INSERT INTO students VALUES (2, 'Joanna', 'F','Namur');
insert into students values (3, 'Jean', 'M','Ixelles');
insert into students values (4,'John','M','Molenbeek');
insert into students values (5,'Odette','F','Woluwé-Saint-Lambert');
insert into students values (6,'Yves','M','Laeken');
insert into students values (7,'Carine','F','Beauraing');
insert into students values (8,'Lalie','F','Dinant');
insert into students values (9, 'Mila','F','Arlon');
insert into students values (10, 'Isabelle','F','Jambes');
insert into students values (11,'Justin','M','Dave');
insert into students values (12,'Brigitte','F','Gembloux');
insert into students values (13,'Olivier','M','Rixensart');
insert into students values (14,'Karl','M','Rhode-Saint-Genèse');
-- fetch some values
SELECT * FROM students WHERE gender = 'F' or gender = 'M';
select * from students ;
select * from students where name = 'Ryan' ;
select * from students where name = 'Joanna' or gender = 'F';  
select *from students where name ='Lalie' or town ='Jambes' ; 
select * from students where name = 'Jean' and town = 'Ixelles' ;