NBCUniversal Interview Question

Describe a complex SQL query you've done.