Through HR.

First round is as usual: SQL and coding (Python I chose). The interviewer gave some tips to solve both SQL and coding parts. I was a little nervous initially and came out of it as she was talking nicely.

SQL (Sales, promotions, products DB): I was able to complete only 3 questions.

Python: Solved only 3 questions.

• Find a given letter in a string.
• Replace None with the previous element from a list. There were some challenges:
  • [None]
  • [None, 1, 2] ==> [None, 1, 2]
  • [1, None, 2] ==> [1, 2, 2]
  • [1, 4, None, None, 3] ==> [1, 4, 4, 4, 3]

Forgot one question.

In the SQL part, please make sure you learn how to calculate %.