← Questions

Customers who rented in two consecutive weeks (SQL)

0
MetaCodingLast asked Sep 2025

Among customers who made purchases in two consecutive full weeks of 2024, return the customer with the most copies rented in the first of those two weeks. Expect to extract the year and week from dates and to use one or two CTEs.

Write and test your solution herePython in your browser, the question's tests level by level, every submission kept for you.Sign in to start coding