SQL Practice Logo

SQLPractice Online

Level 8 - PrincipalDebugging Questionsm4 streaming cdc events

Debug Invalid Latest-Row Aggregation

Fix SQL: SELECT customer_id, MAX(version_no), status FROM cdc_customers GROUP BY customer_id;

Schema Context

cdc_customers(customer_id, version_no, status, event_ts)