I applied online, took them 1 week to contact me. HR was not being so friendly, he used the tone like: after reviewing your application, I was asked to contact you instead of I want to interview you.
Next, there was an SQL exercise to be done within 48 hours. 11 questions total along with 3 data sets, not so easy since I am kind new to SQL. However, I still got most of the questions done. (In the exercise, they says we do not expect you to finish every questions, but also care about your thinking process)
A week later, I got contacted by the HR again and scheduled for an technical interview with the "team". After a brief introductions, there were 2 parts: 1) brain teasers, 2) SQL skills. I would say that the brain teasers questions were difficult and I wasn't much prepared for. The "team" were nice, they walked me through most of them. After the technical interview, they sent me a rejection email.
To be honest, I only applied for Riot Games, because of the fact I have been playing LOL for quite a while. However, if you read other reviews. It seems like Riot Games is definitely not a good place to work, there was a lot of culture fit issues, as well as your personal development along with the long run of the company.
I think that I will stop buying RP based on the SQL exercise. Since most of the questions were about "how to monetize". I know money is definitely one of the important factor to keep the business running, but I had rather to work in a company where they value their user experience more than just how to monetize.