Aylık Aktif Kullanıcı Sayısı

Şema

CREATE TABLE app_opens (
  open_id INTEGER PRIMARY KEY,
  user_id INTEGER NOT NULL,
  opened_at TEXT NOT NULL
);

INSERT INTO app_opens (open_id, user_id, opened_at) VALUES
  (1, 1, '2025-01-05'),
  (2, 2, '2025-01-06'),
  (3, 1, '2025-01-20'),
  (4, 3, '2025-01-25'),
  (5, 1, '2025-02-02'),
  (6, 2, '2025-02-03'),
  (7, 4, '2025-02-10'),
  (8, 2, '2025-02-15'),
  (9, 5, '2025-02-20'),
  (10, 1, '2025-03-01'),
  (11, 3, '2025-03-05'),
  (12, 6, '2025-03-10'),
  (13, 6, '2025-03-15'),
  (14, 7, '2025-03-20');