TikTok interview question

The first round is pure SQL coding which I went through 3 SQL questions over hackerrank. The difficulties is about at most medium. The second round is based on my resume exp. Went through streaming processing and Kafka understanding. Followed by question how to optimized Kafka consuming lagging and data skewness issue in Spark. Then for the remaining 30 mins, went through a simple SQL question and a simple Python question (not even an algo question) and a system design question in shorts.