Domanda di colloquio di Convex

Python: - Binary tree traversal - Write a function which finds the intersection of two unsorted arrays SQL: - Calculate the moving average of a 7 day window (current + 6 last days) - Calculate the transactions per year in a single query for the last three years System Design: - Design a pipeline at as much detail as I would like - Explain rationale and reasoning for certain components - Follow up questions on how I might design certain components based on change Behavioral: - How I handle stress/difficult situations - Scenarios where I can get frustrated - A personal weakness I've encountered and how I overcame it