[s.....x]

#sql
robie takie zadanie:
https://www.codewars.com/kata/5811527d9d278b242f000006/train/sql
moje zapytanie wygląda tak:

CREATE VIEW members_approved_for_voucher AS
SELECT members.id, members.name, members.email, SUM(products.price) AS total_spending
FROM members
INNER JOIN sales ON members.id = sales.member_id
INNER JOIN products ON products.id = sales.product_id
GROUP BY members.id
HAVING SUM(products.price)>1000;
SELECT * FROM members_approved_for_voucher;

tylko nie do końca mam pomysł jak to połączyć z tym warunkiem o działach, jakaś wskazówka?

[JaTobieTyMi]

@sinxcosx:

CREATE VIEW members_approved_for_voucher AS
SELECT m.id, m.name, m.email, SUM(p.price) as total_spending
FROM members m, sales s, products p
WHERE m.id