Pregunta de entrevista de Reddit

Medium-difficult SQL questions, requiring either nested subqueries or CTEs, window functions, etc.