Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --Produsele pretul mai mare decat cele vandute inainte de 01.01.2017
- SELECT A.Nume
- FROM Antichitate A, Vanzare V
- WHERE A.CodA = V.CodA AND A.Pret > ALL(SELECT Suma
- FROM Vanzare
- WHERE Data < '2017-01-01')
- SELECT A.Nume
- FROM Antichitate A, Vanzare V
- WHERE A.CodA = V.CodA AND A.Pret > (SELECT AVG(Suma)
- FROM Vanzare
- WHERE Data < '2017-01-01')
- --Produsele pretul mai mic decat cele vandute in data de 01.01.2017
- SELECT A.Nume
- FROM Antichitate A, Vanzare V
- WHERE A.CodA = V.CodA AND A.Pret < ANY(SELECT Suma
- FROM Vanzare
- WHERE Data = '2017-01-01')
- SELECT A.Nume
- FROM Antichitate A, Vanzare V
- WHERE A.CodA = V.CodA AND A.Pret < (SELECT AVG(Suma)
- FROM Vanzare
- WHERE Data = '2017-01-01')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement