Advertisement
natsageeva

test1

Dec 12th, 2018
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.93 KB | None | 0 0
  1. SELECT avg(Tmp_1.summ)
  2. FROM (
  3.     SELECT strftime("%m, %Y", Purchases.DATE) AS MONTH, SUM(Items.price) AS summ
  4.     FROM Users
  5.     INNER JOIN Purchases ON Users.userid = Purchases.userid
  6.     INNER JOIN Items ON Purchases.itemid = Items.itemid
  7.     WHERE (Users.age >= 18) AND (Users.age <= 25)
  8.     GROUP BY MONTH) AS Tmp_1;
  9.    
  10. SELECT avg(Tmp_2.summ)
  11. FROM (
  12.     SELECT strftime("%m, %Y", Purchases.DATE) AS MONTH, SUM(Items.price) AS summ
  13.     FROM Users
  14.     INNER JOIN Purchases ON Users.userid = Purchases.userid
  15.     INNER JOIN Items ON Purchases.itemid = Items.itemid
  16.     WHERE (Users.age >= 26) AND (Users.age <= 35)
  17.     GROUP BY MONTH) AS Tmp_2;
  18.    
  19. SELECT avg(Tmp_3.summ)
  20. FROM (
  21.     SELECT strftime("%m, %Y", Purchases.DATE) AS MONTH, SUM(Items.price) AS summ
  22.     FROM Users
  23.     INNER JOIN Purchases ON Users.userid = Purchases.userid
  24.     INNER JOIN Items ON Purchases.itemid = Items.itemid
  25.     GROUP BY MONTH) AS Tmp_3;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement