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

CREATE TABLE CLIENTS (
    ClientID INTEGER PRIMARY KEY,
    Nom CHARACTER VARYING (25),
    Prénom CHARACTER VARYING (20),
    Adresse CHAR (30),
    Téléphone CHARACTER VARYING (15)
    );

CREATE TABLE FactureEuro (
    FacId INTEGER PRIMARY KEY,
    ClientID INTEGER,
    EmpID INTEGER,
    TotalVenteEuro CHAR (10),
    TaxeEuro CHAR (3),
    PortEuro CHAR (5),
    GrandTotal CHAR (8); 

CREATE TABLE FactureUS (
    
    
);
-- insert some values
INSERT INTO students VALUES (1, 'Ryan', 'M','cousin','Brien','Van Lanker','Brabant');
INSERT INTO students VALUES (2, 'Joanna', 'F','cousine','Horta','Gendebien','Liège');
INSERT INTO students VALUES (3, 'Carine', 'F','cousine','Brien','Gendebien','Namur');
INSERT INTO students VALUES (4, 'Solange', 'F','cousine','Horta','Van Lanker','Liège');
INSERT INTO students VALUES (5,'Brigitte','F','cousine','Brien','Gendebien','Anvers');
INSERT INTO students VALUES (6,'Yérim','M','cousin','Horta','Gendebien','Liège');

INSERT INTO CLIENTS VALUES (1,'Malanda','Carine', 'Rue des Alliés 255','0479/486539');

INSERT INTO FactureEuro VALUES (1,'33','310','200500','21','23','215000');


-- fetch some values
SELECT * FROM students WHERE gender = 'F' or gender = 'M' or hospital = 'Horta'  or familly = 'cousin' or area = 'Liège' ;
SELECT * FROM CLIENTS WHERE TaxeEuro = '21';
SELECT * FROM FactureEuro WHERE TaxeEuro  = '21';