-- create a table
CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  gender TEXT NOT NULL
);

create table trains (
    id integer primary key,
    nametrain text not null,
    destination text not null
); 

-- insert some values
INSERT INTO students VALUES (1, 'Ryan', 'M');
INSERT INTO students VALUES (2, 'Joanna', 'F');
insert  into students values (3,'Eric','M');
insert into students values (4,'Carine','F');
 insert into students values (5,'Philippe','M');   

insert into trains values (1,'intercity','Charleroi');
insert into trains values (2,'interrégion','Namur');
    
-- fetch some values
SELECT * FROM students WHERE gender = 'F' or gender = 'M';
select * from trains ;