-- 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 N,
    EmpID INTEGER,
    TotalVenteEuro CHAR (10),
    TaxeEuro CHAR (3),
    PortEuro CHAR (5),
    GrandTotal CHAR (8)); 

CREATE TABLE FactureUS (
    FacId INTEGER PRIMARY KEY,
    CLIENTSId INTEGER PRIMARY KEY,
    EmpID INTEGER,
    TotaVenteUS CHAR (10),
    TaxeUS CHAR(5),
    PortUS CHAR (5),
    GrandTotal CHAR (8)):
    
    

-- 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 Ananas 255','0479/486539');

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

INSERT INTO FactureUS VALUES (1, 1 ,'310','200500','21','36','430000');


-- 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 CLIENTSId = 1 ;
SELECT * FROM FactureEuro WHERE PortEuro = '21';
SELECT * FROM FactureUS WHERE PortUS ='21' ;