Invata Interview Question

Describe the most complex SQL statement you've ever written.