1 SELECT num-obj, description
FROM Objet
WHERE type="frise"
AND
annee BETWEEN 200 AND 299


2 SELECT num-obj, description,nom
FROM Objet O, Musee M
WHERE O.num-musee
AND type="frise"
AND
annee BETWEEN 200 AND 299


3 SELECT 
FROM Auteur A, Cooperation C, Publication P, Reference R, Objet O
WHERE A.num-aut=C.num-aut
AND C.num-pub=P.num-pub
AND P.num-pub=R.num-pub
AND R.num-obj=O.num-obj
AND
civilisation LIKE "Dorienne"


4 SELECT COUNT(num-obj), civilisation
FROM Objet
WHERE type="statue"
GROUP BY civilisation


5 SELECT civilisation
FROM Objet
WHERE type="vase"
Group by civilisation
HAVING COUNT(num-obj)