Exploitation_BDD_requêtes_SQL

SELECT
    name AS Nom,
    age AS Âge,
    CASE
        WHEN is_male THEN 'Homme'
        ELSE 'Femme'
    END AS Genre,
    height AS Taille,
    years_studied AS Années_d'études,
    CASE
        WHEN NOT is_working THEN 'Oui'
        ELSE 'Non'
    END AS Disponibilité_professionnelle
FROM
    Personnes
WHERE
    age > 25
    AND years_studied >= 3
    AND NOT is_working;

Tableau 1 résultant : "Candidats disponibles à l'embauche"

name,age,is_male,height,years_studied,is_working
Pablo,26,True,2,8,False
Pedro,30,True,2,4,False
Georgette,45,True,2,8,False
Bernadette,56,False,2,4,False

Tableau 1 résultant : "Candidats disponibles à l'embauche"

SELECT
    name AS Nom,
    age AS Âge,
    CASE
        WHEN is_male THEN 'Homme'
        ELSE 'Femme'
    END AS Genre,
    height AS Taille,
    years_studied AS Années_d'études,
    CASE
        WHEN is_working THEN 'Oui'
        ELSE 'Non'
    END AS Disponibilité_professionnelle
FROM
    Personnes
WHERE
    age <= 25
    OR years_studied < 3
    OR is_working;


name,age,is_male,height,years_studied,is_working
Roland,22,True,2,3,False
Roberta,34,False,2,5,True
Martine,44,False,2,3,True
Alain,56,True,2,0,True
Jean-Paul,24,True,2,3,False
Marjolaine,22,False,2,0,True