مسارات وأدلة برمجية بالعربية، مرتّبة خطوة بخطوة

CREATE TABLE orders (
  id INT PRIMARY KEY,
  customer_id INT,
  amount INT NOT NULL
);
INSERT INTO orders VALUES
  (1, 1, 600), (2, 1, 500),
  (3, 2, 1000),
  (4, 3, 700), (5, 3, 200);
SELECT customer_id, SUM(amount) AS total_amount
FROM orders
GROUP BY customer_id
HAVING SUM(amount) > 1000;