SQL creating a view

CREATE VIEW members_approved_for_voucher AS
SELECT 
  m.id as id
  , m.name as name
  , m.email as email
  , SUM(p.price) total_spending
FROM sales s
  JOIN products p ON s.product_id=p.id
  JOIN members m ON s.member_id=m.id
WHERE s.department_id IN
  (SELECT s.department_id
  FROM sales s
    JOIN products p ON s.product_id=p.id
  GROUP BY s.department_id
  HAVING SUM(p.price)>10000)
GROUP BY 1,2,3
HAVING SUM(p.price)>1000
ORDER BY m.id;

SELECT * from members_approved_for_voucher;
CREATE VIEW members_approved_for_voucher AS
SELECT 
  m.id
  , m.name
  , m.email
  , SUM(p.price) total_spending
FROM 
  sales s
  , members m
  , products p
WHERE 
  s.member_id=m.id
  AND s.product_id=p.id
  AND s.department_id IN (
    SELECT s.department_id
    FROM sales s JOIN products p ON s.product_id=p.id
    GROUP BY department_id
    HAVING SUM(p.price)>10000
  )
GROUP BY 1,2,3
HAVING SUM(p.price)>1000
ORDER BY 1;
  
SELECT * FROM members_approved_for_voucher;