Solutions

Solution Exercice 1 :

INSERT INTO clients (nom, email, date_inscription)
VALUES ('Alice Dupuis', '[email protected]', '2023-09-10'),
       ('Marc Petit', '[email protected]', '2023-09-12');

Solution Exercice 2 :

SELECT nom, email
FROM clients
WHERE date_inscription > '2023-09-01';

Solution Exercice 3 :

UPDATE clients
SET email = '[email protected]'
WHERE id = 2;

Solution Exercice 4 :

DELETE FROM clients
WHERE id = 3;