Meta interview question

SQL questions. You can solve it in Pandas though