Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT AVG(pi.amount * pr.price), EXTRACT(MONTH FROM DATE)
- FROM PurchaseItem pi
- INNER JOIN Purchase pu ON pu.id = pi.purchase_id
- INNER JOIN Product pr ON pr.id = pi.product_id
- WHERE EXTRACT(YEAR FROM DATE) = 2019
- GROUP BY EXTRACT(MONTH FROM DATE)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement