WITH edit_dates AS

(

  SELECT

    DATE(rev_timestamp) AS date,

    COUNT(rev_id) AS edits

  FROM revision LEFT JOIN actor ON (revision.rev_actor = actor.actor_id)

  -- Điền tên người dùng đây

  WHERE actor.actor_name = "Nguyentrongphu" -- Nếu muốn xem cột mốt cho cả Wikipedia thì xóa luôn lệnh này.

  GROUP BY date

  ORDER BY date ASC

)

SELECT date AS ngày, SUM(edits) over (ORDER BY date) AS tổng_sửa_đổi_từ_khi_mới_tham_gia FROM edit_dates;