-- Numarul de antichitati achizitionate organizat pe categorii, avand suma cheltuita peste medie

SELECT CA.Nume, COUNT(Ac.CodA) AS [Nr. Achizitii]
	FROM Categorie CA, Achizitie Ac, Antichitate A
	WHERE Ca.CodCA = A.CodCA AND A.codA = Ac.CodA
GROUP BY CA.Nume
HAVING SUM(Ac.Suma) > (SELECT AVG(Suma) FROM Achizitie)
ORDER BY [Nr. Achizitii]

-- Valoarile peste medie a vanzarilor efectuate de un vanzator

SELECT V.Nume,V.Prenume, COUNT(Va.CodV) AS [Nr. Vanzari], AVG(Va.Suma) AS [Media]
	FROM Vanzator V, Vanzare Va
	WHERE Va.CodV = V.CodV
GROUP BY V.Nume, V.Prenume
HAVING SUM(Va.Suma) > (SELECT AVG(Suma) FROM Vanzare)
ORDER BY [Media] DESC