Lightspeed Interview Question

SQL window function related queries, In system design CI/CD process