TikTok Software Developer interview questions

OA: There are five questions in total. The SQL question will use groupby and CTE. The coding question are medium level array and string questions. The sliding window will be tested. (you won't pass all the test if your solution is O(n2)

The first round is online assessment which has two questions about the theory, one SQL, two algorithms. The two algorithms I did were all about stirng manipulation. I think the emphasis is on the code implementation rather than the logic.