Skip to main content
Journey Uncommon Logo
JourneyUncommon
mediumSQLself-joinsSingle-choice MCQ

Using a self-join to compute a running comparison, what does this query return for each row?

SELECT t1.day, COUNT(t2.day) AS running_count FROM events t1 JOIN events t2 ON t2.day <= t1.day GROUP BY t1.day;