NBCUniversal interview question

Describe a complex SQL query you've done.