SQL Practice Logo

SQLPractice Online

Company SQL Question

Average Time Between Posts

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

Problem Statement

Calculate average inter-post gap days for multi-post users using LAG() window function and two CTEs.

Relevant Tables

usersposts

SQL Concepts Used in This Question

Strengthen your understanding with these targeted learning topics: