Riot Games interview question

A Python coding question and a SQL query you need to write.