SQL Practice Logo

SQLPractice Online

Level 8 - PrincipalQuery-Based Questionsm4 streaming cdc events

Latest Version per Customer from CDC

Write SQL to keep latest version_no per customer_id from cdc_customers.

Schema Context

cdc_customers(event_id, customer_id, version_no, status, event_ts)