Pergunta de entrevista da empresa PCL Construction

The most complex query I worked on and what made it so difficult?