Company SQL Question

Average Time Between Posts

Practice this Meta style SQL interview question with live execution and instant feedback.

Problem Statement

Calculate the average time gap (in days) between consecutive posts for each user who has posted at least 2 times. Show username, total posts, and average gap in days.

Relevant Tables

usersposts

SQL Concepts Used in This Question

Strengthen your understanding with these targeted learning topics:

Running Totals & Moving AveragesWindow Functions
Conditional Aggregation with CASE & FILTERAggregate Functions & Grouping
ROW_NUMBER, RANK, DENSE_RANKWindow Functions