Spotify DS Interview Experience
For anyone else interviewing with Spotify.
Google Hangout style interview with coderpad.
Section 1: SQL
Join two tables together to get a specific end result.
Make a query to get the top n records in each group.
Section 2: Coding challenge.
Write a function to test if a number is prime.
I ended up just running a loop for each number n to see if input % n = 0 if found, return false.
The original algorithm counted down, I optimized it by rewriting the algorithm to count up and stop at the halfway mark.