Advertisement
Guest User

Untitled

a guest
Mar 27th, 2017
47
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.20 KB | None | 0 0
  1. SELECT t2.ID AS ID,
  2.        t2.U*AVGverdi Cost
  3.      FROM
  4.       t2 t2,
  5.     t3 t3
  6.    
  7.  WHERE t2.ID=t3.ID
  8.         AND (SELECT t3.ID, AVG(t3.X/t3.y) AS AVGverdi
  9.             FROM t3 t3
  10.             GROUP BY t3.ID)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement