Customers who rented in two consecutive weeks (SQL)
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.
MetaTechnical phone screenNo answer yet. Write the first one; the best answer gets endorsed.