Courses Booked Heavily in Two Consecutive Years

Problem

An online learning platform records course enrolments. Table `bookings` has `(booking_id, course_id, seats, booked_on)` where `booked_on` is a date.

Find the `course_id` of every course that was booked four or more times (four or more booking rows) within a single calendar year in each of two consecutive years. In other words, there exists some year Y such that the course has at least 4 bookings in year Y and at least 4 bookings in year Y+1.

Return the result in any order.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 1 row with the columns course_id.

Starter code (SQL)

SELECT *
FROM bookings;

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