CREATE TABLE Etudiant (
    id_etudiant  INT           PRIMARY KEY,
    nom          VARCHAR(50)   NOT NULL,
    prenom       VARCHAR(50)   NOT NULL,
    moyenne      DECIMAL(4,2)  CHECK (moyenne BETWEEN 0 AND 20)
);

INSERT INTO Etudiant (id_etudiant, nom, prenom, moyenne) VALUES
(90, 'LAMBERT',  'Sarah',   12.75),
(91, 'FONTAINE', 'Lucas',    7.50),
(92, 'CHEVALIER','Manon',   16.20),
(93, 'ROUSSEAU', 'Théo',     8.00),
(94, 'BLANC',    'Camille',  5.25),
(95, 'GUERIN',   'Noah',    10.40),
(96, 'MULLER',   'Jade',     7.99),
(97, 'HENRY',    'Louis',   13.10),
(98, 'PERRIN',   'Zoé',      3.80),
(99, 'MOREL',    'Adam',    11.00);

INSERT INTO Etudiant  (id_etudiant, nom, prenom, moyenne)
VALUES (101, 'DUPONT','MARTIN', 14.5);

UPDATE Etudiant
SET moyenne=15.2
WHERE id_etudiant=101;

DELETE FROM Etudiant
WHERE moyenne <8;