Pregunta de entrevista de NBCUniversal

Describe a complex SQL query you've done.