1. SQL and Python Coding Test
The SQL and Python coding test consists of 7 questions: 5 SQL and 2 Python. The time limit for each question varies based on difficulty, with a limit of either 5 or 10 minutes. The SQL questions are of medium difficulty, similar to those on LeetCode. For the Python questions, one is easy and can be quickly solved using an ordered dictionary. The second Python question is a small algorithmic challenge where you are given a list of words and you must merge them into one long word by connecting them according to the rule that the last letter of a word matches the first letter of the next word. For example, given the words 'abc', 'rgn', 'ctr', the result would be 'abctrgn'. Completing at least 5 SQL questions and one Python question should be sufficient to pass.