Advertisement
Guest User

Untitled

a guest
Feb 25th, 2020
104
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(pi.amount * pr.price), EXTRACT(MONTH FROM DATE)
  2. FROM PurchaseItem pi
  3. INNER JOIN Purchase pu ON pu.id = pi.purchase_id
  4. INNER JOIN Product pr ON pr.id = pi.product_id
  5. WHERE EXTRACT(YEAR FROM DATE) = 2019
  6. GROUP BY EXTRACT(MONTH FROM DATE)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement