SQL: A running total with a window

Written for TypingKit · ~1 min

0 wpm 100% accuracy 100% real accuracy

SELECT day,↵
signups,↵
SUM(signups) OVER (ORDER BY day) AS total↵
FROM (↵
SELECT DATE(created_at) AS day, COUNT(*) AS signups↵
FROM users↵
GROUP BY DATE(created_at)↵
) AS daily↵
ORDER BY day;