Group by Status

-- Drill 09 — تجميع الطلبات حسب الحالة — SQLite 3.x+
CREATE TABLE orders (
  status TEXT NOT NULL,
  total_halalas INTEGER NOT NULL
);

INSERT INTO orders VALUES
  ('paid', 5000),
  ('paid', 7000),
  ('draft', 3000);

SELECT
  status,
  COUNT(*) AS order_count,
  SUM(total_halalas) AS total_sum_halalas
FROM orders
GROUP BY status
ORDER BY total_halalas DESC;