Solutions

Solutions Exercice 1 :

SELECT nom, email
FROM clients
WHERE ville = 'Lyon';

Solutions Exercice 2 :

SELECT nom, email
FROM clients
WHERE ville = 'Marseille' AND date_inscription < '2023-06-01';

Solutions Exercice 3 :

SELECT nom, email
FROM clients
WHERE date_inscription BETWEEN '2023-01-01' AND '2023-06-30'
AND nom LIKE 'J%';