Same-Week Repeat Buyers

Analytics Reporting Track · Medium · 25 min

Count the number of users who placed at least two orders in the same calendar week. Return a single value named repeat_buyers.

Analytics Reporting Track

Medium

25 min

query basics

aggregation

date functions

Company labels are directional practice context, not official interview guidance.

Timer 00:00

Practice query basics through a Etsy-tagged business scenario.

Use this track to train on SQL that mirrors day-to-day analytics workflows and recurring reporting asks.

Company labels are directional practice context, not official interview guidance.

Prereq: query basics

Prereq: filtering

Count the number of users who placed at least two orders in the same calendar week. Return a single value named repeat_buyers.

Pro question

Upgrade to Pro to unlock this prompt, the SQL workspace, and all 254 problems.

Editor

Run queries against the protected question data, then submit once the result shape looks right.

Create a free account or sign in before running queries against protected question data.