Teslim Edilmemiş Gönderiler

Şema

CREATE TABLE deliveries (
  delivery_id INTEGER PRIMARY KEY,
  customer_name TEXT NOT NULL,
  city TEXT NOT NULL,
  dispatched_at TEXT NOT NULL,
  delivered_at TEXT
);

INSERT INTO deliveries (delivery_id, customer_name, city, dispatched_at, delivered_at) VALUES
  (1, 'Ahmet Yıldız', 'İstanbul', '2025-03-01', '2025-03-03'),
  (2, 'Zeynep Kaya', 'Ankara', '2025-03-02', NULL),
  (3, 'Mehmet Demir', 'İzmir', '2025-03-02', '2025-03-04'),
  (4, 'Ayşe Şahin', 'Bursa', '2025-03-03', NULL),
  (5, 'Fatma Çelik', 'Antalya', '2025-03-03', '2025-03-05'),
  (6, 'Ali Aydın', 'Konya', '2025-03-04', NULL),
  (7, 'Elif Arslan', 'Adana', '2025-03-04', '2025-03-06'),
  (8, 'Mustafa Koç', 'Gaziantep', '2025-03-05', '2025-03-07'),
  (9, 'Hatice Er', 'Kayseri', '2025-03-05', NULL),
  (10, 'Hüseyin Bulut', 'Mersin', '2025-03-06', '2025-03-08'),
  (11, 'Emine Yavuz', 'Diyarbakır', '2025-03-06', NULL),
  (12, 'İbrahim Öz', 'Eskişehir', '2025-03-07', '2025-03-09');