-- create a table
CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  gender TEXT NOT NULL,
  immatricule integer var(4) , 
  type-repas text not null  
);
create table repas (
    id integer primary key ,
    name text not null,
    gender text not null
);
-- insert some values
INSERT INTO students VALUES (1, 'Ryan', 'M',2365,'allal');
INSERT INTO students VALUES (2, 'Joanna', 'F',2357,'porc');
insert into students values (3, 'Eric','M',2358,'porc');
insert into students values (4, 'Frédéric','M',2359,'porc');
insert into  students values (5,'Chantal','F',2360,'allal';
insert into students values (6,'Marie','F',2361,'porc');
insert into students values (7,'Jean','M',23622,'allal');

insert into repas values (1,'allal','végétarien');
insert into repas values (2,'non allal','porc');
-- fetch some values
SELECT * FROM students WHERE gender = 'F' or gender = 'M';
select * from students where gender = 'F';
select * from students where name = 'Joanna';
select * from students where immatricule = 2357 ;
select * from repas ;