Invata interview question

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