Round 1
Questions:
-
SQL: Write SQL code to show the previous sale and next sale for each date?
Sample Data:
date, sales_amount 10-10-2022, 2500 18-10-2022, 1600 12-10-2022, 1200 13-10-2022, 1500 14-10-2022, 700 20-10-2022, 2400 11-10-2022, 1000 16-10-2022, 2000 17-10-2022, 1900 15-10-2022, 900 19-10-2022, 3200
- What are the optimization techniques you have used before?
- What are the differences between CTEs and Temp tables?
Specific question not provided.
Candidate's Approach
I was able to explain the logic of the query but failed to write the correct one. The interview felt rushed, and I was informed that there were only 2 minutes left to conclude.
Interviewer's Feedback
Overall, I felt like they understood that I was not a good fit for the team. The hiring manager seemed uninterested, and the interview ended 15 minutes early since I did not ask any questions as I could sense their disinterest.