Advertisement
Guest User

Untitled

a guest
Dec 15th, 2018
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.40 KB | None | 0 0
  1. WITH
  2. avgs AS
  3.     (SELECT userid, AVG(price) AS av FROM Purchases
  4.         INNER JOIN Items ON Items.itemid = Purchases.itemid
  5.     GROUP BY userid)
  6. SELECT AVG(av) FROM avgs
  7.     INNER JOIN Users ON Users.userid = avgs.userid
  8.     WHERE age BETWEEN 18 AND 25
  9. UNION
  10. SELECT AVG(av) FROM avgs
  11.     INNER JOIN Users ON Users.userid = avgs.userid
  12.     WHERE age BETWEEN 16 AND 35
  13. UNION
  14. SELECT AVG(av) FROM avgs;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement