Exploitation_BDD_SQL : C 1. Structured Query Language - SELECT

"CANDIDATS DISPONIBLES A 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 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 RESULTANT : "CANDIDATS DISPONIBLES A L'EMBAUCHE"

NOM,ÂGE,GENRE,TAILLE,ANNEES_D'ETUDES,DISPONIBILITE_PROFESSIONNELLE
Pablo,26,Homme,2,8,Oui
Pedro,30,Homme,2,4,Oui
Georgette,45,Homme,2,8,Oui
Bernadette,56,Femme,2,4,Oui


"CANDIDATS A EXCLURE DU RECRUTEMENT"

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;

TABLEAU 2 RESULTANT : "CANDIDATS A EXCLURE DU RECRUTEMENT"

NOM,ÂGE,GENRE,TAILLE,ANNEES_D'ETUDES,DISPONIBILITE_PROFESSIONNELLE
Roland,22,Homme,2,3,Non
Roberta,34,Femme,2,5,Oui
Martine,44,Femme,2,3,Oui
Alain,56,Homme,2,0,Oui
Jean-Paul,24,Homme,2,3,Non
Marjolaine,22,Femme,2,0,Oui