Members With a Quick Repeat Borrow

Problem

Table: `borrow_log`

| Column Name | Type |
|---|---|
| member_id | int |
| title | varchar |
| borrowed_on | date |
| fee_cents | int |

There is no primary key; a member may borrow several titles, and the same member can appear on many dates. Each row records a single borrow event.

A member is *engaged* if they have two borrow events whose dates are 7 days apart or less (consecutive in time for that member). Report the `member_id` of every engaged member, each id once. Return them in any order.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 1 row with the columns member_id.

Starter code (SQL)

SELECT *
FROM borrow_log;

Related SQL questions

• 3-Day Tweet Rolling AverageMedium
• 7-Day vs 28-Day Rolling Avg DivergenceMedium
• A/B Test Sample Ratio Mismatch (SRM) CheckMedium
• Accounts Streaming From Two Devices at OnceMedium
• Ad Campaign Funnel AnalysisMedium
• Agent Resolution RateMedium