•	Solution de l'exercice 1:
SELECT Nom, Prenom, Age FROM Personne WHERE Age > 50

•	Solution de l'exercice 2:
SELECT Nom, Prenom, Age FROM Personne INNER JOIN Langue ON Personne.Id_langue = Langue.Id WHERE Libelle = 'Français' AND Nom LIKE 'DU%'

•	Solution de l'exercice 3:
SELECT Nom, Prenom, Age FROM Personne ORDER BY Nom LIMIT 3

•	Solution de l'exercice 4:
SELECT AVG(Age) as Age_moyen, Libelle as Langue FROM Personne INNER JOIN Langue ON Personne.Id_langue = Langue.Id GROUP BY Id_langue

•	Solution de l'exercice 5:
SELECT ROUND(AVG( Age )) AS Age_moyen_arrondi, Libelle AS Langue
FROM Personne
INNER JOIN Langue ON Personne.Id_langue = Langue.Id
GROUP BY Id_langue
HAVING Libelle LIKE '%ais%'

•	Solution de l'exercice 6:
SELECT CONCAT(SUBSTR(Nom,1,3),' ',SUBSTR(Prenom,1,3)) as Nom_prenom FROM Personne WHERE Age > 30
UNION
SELECT CONCAT(SUBSTR(Nom,LENGTH(Nom)-2),' ',SUBSTR(Prenom,LENGTH(Prenom)-2)) as Nom_prenom FROM Personne WHERE Age < 30

•	Solution de l'exercice 7:
SELECT Nom,IF(LENGTH(Nom) = 6 ,CURRENT_TIME,ADDTIME(CURRENT_TIME, '01:00:00')) as horaire FROM `Personne`

•	Solution de l'exercice 8:
SELECT Libelle FROM Langue WHERE Id NOT IN (SELECT Id_langue From Personne WHERE Nom='Dupont')

•	Solution de l'exercice 9:
SELECT SUM(Age) as Somme_Age, Libelle as Langue FROM Personne INNER JOIN Langue ON Personne.Id_langue = Langue.Id GROUP BY Id_langue HAVING Id_langue NOT IN (SELECT Id_langue FROM Personne WHERE Age BETWEEN 25 AND 27 )
