ZS Associates interview question

Sql, window function, etl, data pipeline, kafka