Having Customers

-- Drill 10 — تصفية المجموعات بـ HAVING — SQLite 3.x+
CREATE TABLE orders (
  customer_id INTEGER NOT NULL,
  total_halalas INTEGER NOT NULL
);

INSERT INTO orders VALUES
  (1, 5000),
  (1, 7000),
  (2, 3000);

SELECT
  customer_id,
  COUNT(*) AS order_count
FROM orders
GROUP BY customer_id
HAVING COUNT(*) >= 2;