Advertisement
Guest User

Untitled

a guest
Nov 13th, 2019
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.25 KB | None | 0 0
  1. select avg(Viteza) as VitezaMedie
  2. from laptop_uri
  3. where Pret >1000;
  4.  
  5. select Hd
  6. from PC_uri
  7. group by Hd
  8. Having count(*) >= 2;
  9.  
  10. select Producator, Max(Pret)
  11. from PC_uri
  12. inner join Produse on PC_uri.model=Produse.model
  13. group by Producator;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement