JAJAJAJJAJAJAJAAAA

pdg 1 :
SELECT n°siret, raisonsoc
FROM entreprise
WHERE n°siret not in (
select en.n°siret
from entreprise en, travailler tr, typetravaux ty, employe em
where em.n°siret=en.n°siret
and em.codeE=tr.codee
and tr.codety=ty.codety
and ty.nomty="Maçonerie"
and tr.datet between #01/01/2009# and #12/31/2009#);

pdg2:
SELECT vi.codev, vi.nomv
FROM ville AS vi, travailler AS tr, chantier AS ch
WHERE vi.codev=ch.codev
and ch.codech=tr.codech
GROUP BY vi.codeV, vi.nomv
HAVING sum(tr.nbheuretrav)>1000;

pdg3:
SELECT em.codeE, sum(tr.nbHeureTrav * ty.tarif_Heure_Employe) AS [montant reservé]
FROM employe AS em, qualif AS qu, travailler AS tr, typetravaux AS ty
WHERE qu.codeQ=em.codeq
and em.codee=tr.codeE
and tr.codety=ty.codety
and qu.niveauq="Bac Pro"
GROUP BY em.codee
HAVING sum(tr.nbHeureTrav)>100;

sspdg4:
SELECT em.codee, Sum(tr.nbheuretrav*ty.tarif_heure_employe) AS somme
FROM employe AS em, travailler AS tr, typetravaux AS ty
WHERE (((em.codee)=[tr].[codee])
AND ((tr.codety)=[ty].[codety]))
GROUP BY em.codee;

pdg4:
SELECT codee, somme
FROM ssreq4
WHERE somme=(select max(somme) from ssreq4 );

pdg5:
SELECT vi.regionV, count(ch.codech) AS nbre
FROM ville AS vi, chantier AS ch
WHERE vi.codev=ch.codev
GROUP BY vi.regionv
ORDER BY 2;