I had an interview in which I had LOADS of confidence but alas felt like I was in the octagon with John Jones.
There were four tasks in total:
- A PostgreSQL query that required the sum of salaries of employees within certain departments. Needless to say, I had several WTF moments but I was able to do some quick googling to at least successfully query some of the data.
- An “identify the bug” problem within some kind of for loop. I forgot what the program was trying to do. This was this one that I felt I got right… I think
- A problem that required me to construct an algorithm as follows: A String S will be comprised of a series of letters of only ‘a’ and ‘b’ that is of length N. For any N of S, write a function that will make the amount of groups of letters equivalent. As an example, if the input was ‘aababa’, the algorithm would output ‘aabbaabbaa’ thus making each group equal with each other.
I’ll write more on this later; unfortunately My break is over