SELECT *
from U;

SELECT *
from U
where U.ville = "Londres";

SELECT NF
from PUF
where NU=1 and NP=1;

SELECT P.NomP, P.Couleur
from P, PUF
where P.NP = PUF.NP and PUF.NF = 1;

select PUF.NF
from PUF, P where PUF.NU=1 and PUF.NP=P.NP and P.Couleur="rouge";

SELECT F.NomF from PUF, F, U, P where PUF.NF = F.NF and PUF.NU = U.NU and PUF.NP = P.NP and (U.Ville = "Londres" or U.Ville = "Paris") and P.Couleur="rouge";

SELECT distinct PUF.NP from PUF, U, F where U.Ville= F.Ville and PUF.NF=F.NF and PUF.NU=U.NU;

SELECT distinct PUF.NP from PUF, U, F where PUF.NF = F.NF and PUF.NU = U.NU and U.Ville = "Londres" and F.Ville = "Londres";

SELECT distinct PUF.NU from PUF, F, U where F.Ville != U.Ville and PUF.NF = F.NF and PUF.NU = U.NU;

SELECT distinct puf1.NF from PUF puf1, PUF puf2 where puf1.NF = puf2.NF and puf1.NU = 1 and puf2.NU = 2;

SELECT distinct PUF.NU from PUF where PUF.NP in (SELECT PUF.NP from PUF where PUF.NF=3);

SELECT P.NP from p where p.Poids in (select min(p.poids) from p);

select u.NU from U u where u.NU not in( select l.NU from PUF l, P p, F f where l.NP = p.NP and l.NF = f.NF and p.Couleur = "rouge" and f.Ville = "Londres" );

SELECT PUF.NF from PUF where PUF.NP in
    (SELECT PUF.NP from PUF where PUF.NF in
        (SELECT PUF.NF from PUF, P where PUF.NP = P.NP and P.Couleur = "rouge"));

SELECT distinct F.Ville as VilleF, PUF.NP, U.Ville AS VilleU from PUF, U, F where PUF.NF = F.NF and PUF.NU=U.NU;