Twitch Data Science Intern Interview Experience — SQL Screen on the Classic Streaming and Viewing Tables

I did a mass application to Twitch's Graduate DS intern program. About two weeks later I got an HR phone screen — they asked why this company and three or four traditional behavioral questions, about 30 minutes total.

A week after that came the technical round: 4-5 SQL questions, all built around two tables related to streaming and viewing. The questions were slightly different from ones already discussed on the forum before — for example, what was the third question in an earlier post ended up being my second question, and the questions got harder from there. I honestly don't remember the exact questions anymore, but you can think about what kinds of questions those two tables would produce. I barely had time to finish the fourth question. The interviewer followed up on my answers a lot.

Now I've got the next round scheduled — 45 minutes with a Senior Data Scientist from the team. I wanted to ask if anyone here knows what the Analytics team's case round usually focuses on, and what skills I should prioritize reviewing — stats, A/B testing, product sense, ML, etc. Also curious what principles I should focus on for the intern behavioral questions. If anyone has interned at Twitch before, I'd love to hear from you too.