-- Produsele vandute in data de 01-01-2017

SELECT A.Nume
	FROM Antichitate A, Vanzare V
	WHERE A.CodA = V.CodA AND V.Data = ALL(SELECT Data
											FROM Vanzare
											WHERE Data = '2017-01-01')

SELECT A.Nume
	FROM Antichitate A, Vanzare V
	WHERE A.CodA = V.CodA AND V.Data NOT IN (SELECT Data
												FROM Vanzare
												WHERE Data < '2017-01-01' OR Data >'2017-01-01' )

-- Produsele vandute inainte de 01-01-2017

SELECT A.Nume
	FROM Antichitate A, Vanzare V
	WHERE A.CodA = V.CodA AND V.Data = ANY(SELECT Data
											FROM Vanzare
											WHERE Data < '2017-01-01')

SELECT A.Nume
	FROM Antichitate A, Vanzare V
	WHERE A.CodA = V.CodA AND V.Data NOT IN (SELECT Data
												FROM Vanzare
												WHERE Data >= '2017-01-01')