Level: Mid-Level
Round: Phone Screen · Type: Coding · Difficulty: 7/10 · Duration: 60 min · Interviewer: Unfriendly
Topics: SQL, Window Functions, Common Table Expressions (CTEs)
Location: Los Gatos, CA
Interview date: 2025-02-15
Got offer: False
I had a technical phone screen where I was expected to code efficiently. I failed because I didn't finish the questions in time.
Question 1: LeetCode-style coding question - LeetCode 901.
Question 2: Easy SQL question.
Question 3: Medium SQL question building on the first question, involving window functions and CTEs.
I should have started coding immediately without hesitation. The time was very limited. For SQL questions, I need to practice writing efficient queries using window functions and CTEs.
LeetCode similar: LeetCode 901