1/ SELECT *
FROM etudiant
2/ SELECT nom,prenom
FROM etudiant
3/ SELECT *
FROM etudiant
WHERE sexe='F';
4/ SELECT *
FROM etudiant
WHERE nom='ben salah ';
5/ SELECT *
FROM etudiant
WHERE date-naissance'>'01-01-2025';
6/ SELECT *
FROM etudiant
WHERE ='Sfex'
7/ SELECT *
FROM etudiant
WHERE code_postal LIKE '%1'
8/ SELECT *
FROM etudiant
WHERE date-naissance LIKE '%2004'
9/
SELECT *
FROM etudiant ORDER BY nom;
10/
SELECT *
FROM etudiant
WHERE prenom LIKE '%i%';
11/
SELECT *
FROM etudiant
WHERE adresse LIKE '%La Marsa';
12/
SELECT *
FROM etudiant
WHERE date_naissance BETWEEN DATE '2005-01-01' AND DATE '2005-12-31';
/13
SELECT *
FROM etudiant
WHERE sexe <> 'M';
14/
SELECT nom, prenom
FROM etudiant
WHERE code_postal IN ('1000', '1002');
15/
SELECT *
FROM etudiant
ORDER BY ville, nom;
16/
SELECT *
FROM etudiant
WHERE TO_CHAR(ninscription) LIKE '%010';
17/
SELECT
COUNT(*) AS total_etudiants
FROM etudiant;
18/
SELECT
COUNT(*) AS nb_femmes
FROM etudiant
WHERE sexe = 'F';
19/
SELECT *
FROM etudiant
WHERE date_naissance = (SELECT MAX(date_naissance) FROM etudiant);
20/
SELECT *
FROM etudiant
WHERE date_naissance = (SELECT MIN(date_naissance) FROM etudiant);
21/
SELECT *
FROM etudiant
WHERE nom LIKE 'A%' AND prenom LIKE 'M%';
22/
SELECT *
FROM etudiant
WHERE ville LIKE '%ou%';
23/
SELECT nom, prenom
FROM etudiant
WHERE adresse NOT LIKE '%rue%';
24/
SELECT DISTINCT ville
FROM etudiant;
25/
SELECT *
FROM etudiant
WHERE nom = prenom;
26/
SELECT *
FROM etudiant
WHERE ninscription = 15;
27/
SELECT *
FROM etudiant
WHERE adresse IS NOT NULL;
28/
SELECT *
FROM etudiant
ORDER BY EXTRACT(MONTH FROM date_naissance);
29/
SELECT nom, prenom
FROM etudiant
WHERE date_naissance = DATE '2004-10-14';
30/
SELECT UPPER(nom)
UPPER(prenom)
FROM etudiant;
31/
SELECT LOWER(ville)
FROM etudiant;
32/
SELECT
MIN(date_naissance) AS plus_vieille_date
FROM etudiant;
33/
SELECT
MAX(date_naissance) AS plus_jeune_date
FROM etudiant;
34/
SELECT
ROUND(AVG(TRUNC(MONTHS_BETWEEN(SYSDATE, date_naissance)/12))) AS age_moyen
FROM etudiant;
35/
SELECT ville
, COUNT(*) AS nb_etudiants
FROM etudiant
GROUP BY ville;
36/.
SELECT nom, prenom
FROM etudiant
WHERE date_naissance = (SELECT MAX(date_naissance) FROM etudiant);
37 /
SELECT *
COUNT(DISTINCT ville) AS nb_villes FROM etudiant;
38/
SELECT ville
COUNT(*) AS nb
FROM etudiant
GROUP BY ville
HAVING COUNT(*) > 2;
/39
SELECT nom
LENGTH(nom) AS nb_caracteres
FROM etudiant;