-- create a table
CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  gender TEXT NOT NULL
);
--fin de create table students
--début de create table de nursing
create table nursing (
    id integer primary key,
    name text not null,
    functiones text not null,
    area text not null
);
--fin de create table nursing
create table docteurs (
    id integer primary key,
    name text not null,
    functiones text not null,
    area text not null 
);
--fin de table des docteurs 
--début de la section des ressources humaines
create table services (
    id integer primary key,
    united text not null,
    name text not null,
    speciality text not null,
    speciality2 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,'Sophie','F');
insert into students values (4,'Eric','M');
insert into students values (5,'Véronica','F');
insert into nursing values (1,'carine','nurse','surgery');
insert into nursing values (2,'Véronica','nurse','surgery');
insert into services values(1,'unité04','chirurgie','PTH','orthopédie');
insert into services values (2,'unité05','médecine','gangrène','vasculaire');
insert into services values (3,'unité06','gériatrie','MAP chute','gérontologie');
--fin de insert
-- fetch some values
SELECT * FROM students WHERE gender = 'F' or gender = 'M';
select * from students where gender = 'M';
select * from students where gender = 'F';
select * from students where gender = 'M' and not gender ='F';
select * from nursing ;
select * from students ;
select * from services ;